/*
 Navicat MySQL Data Transfer

 Source Server         : localhost_vigor
 Source Server Version : 50534
 Source Host           : localhost
 Source Database       : edusoho

 Target Server Version : 50534
 File Encoding         : utf-8

 Date: 03/27/2015 22:24:54 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `article`
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章ID',
  `title` varchar(255) NOT NULL COMMENT '文章标题',
  `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '栏目',
  `tagIds` tinytext COMMENT 'tag标签',
  `source` varchar(1024) DEFAULT '' COMMENT '来源',
  `sourceUrl` varchar(1024) DEFAULT '' COMMENT '来源URL',
  `publishedTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间',
  `body` text COMMENT '正文',
  `thumb` varchar(255) NOT NULL DEFAULT '' COMMENT '缩略图',
  `originalThumb` varchar(255) NOT NULL DEFAULT '' COMMENT '缩略图原图',
  `picture` varchar(255) NOT NULL DEFAULT '' COMMENT '文章头图，文章编辑／添加时，自动取正文的第１张图',
  `status` enum('published','unpublished','trash') NOT NULL DEFAULT 'unpublished' COMMENT '状态',
  `hits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点击量',
  `featured` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否头条',
  `promoted` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '推荐',
  `sticky` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否置顶',
  `userId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文章发布人的ID',
  `createdTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatedTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `article_category`
-- ----------------------------
DROP TABLE IF EXISTS `article_category`;
CREATE TABLE `article_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '栏目名称',
  `code` varchar(64) NOT NULL COMMENT 'URL目录名称',
  `weight` int(11) NOT NULL DEFAULT '0',
  `publishArticle` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否允许发布文章',
  `seoTitle` varchar(1024) NOT NULL DEFAULT '' COMMENT '栏目标题',
  `seoKeyword` varchar(1024) NOT NULL DEFAULT '' COMMENT 'SEO 关键字',
  `seoDesc` varchar(1024) NOT NULL DEFAULT '' COMMENT '栏目描述（SEO）',
  `published` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否启用（1：启用 0：停用)',
  `parentId` int(10) unsigned NOT NULL DEFAULT '0',
  `createdTime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `article_category`
-- ----------------------------
BEGIN;
INSERT INTO `article_category` VALUES ('1', '科技快讯', 'news', '0', '1', '科技', '科技', '科技', '1', '0', '1411054906'), ('3', '今日头条', 'bbs', '1', '1', '', '', '', '1', '0', '1411055743');
COMMIT;

-- ----------------------------
--  Table structure for `block`
-- ----------------------------
DROP TABLE IF EXISTS `block`;
CREATE TABLE `block` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编辑区ID',
  `userId` int(11) NOT NULL COMMENT '编辑区创建人ID',
  `title` varchar(255) NOT NULL COMMENT '编辑区名称',
  `mode` enum('html','template') NOT NULL DEFAULT 'html' COMMENT '模式',
  `template` text COMMENT '模板',
  `templateData` text COMMENT '模板数据',
  `content` text COMMENT '编辑区内容',
  `code` varchar(64) NOT NULL DEFAULT '' COMMENT '编辑区编码',
  `tips` text COMMENT '编辑区编辑提示',
  `createdTime` int(11) unsigned NOT NULL COMMENT '编辑区创建时间',
  `updateTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '编辑区最后更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `block`
-- ----------------------------
BEGIN;
INSERT INTO `block` VALUES ('1', '1', '默认主题：首页头部图片轮播', 'html', null, null, '<a href=\"http://cn.engadget.com/2014/09/18/play-store-material-design-leak/\"><img src=\"/edusoho/web/files/default/2014/09-19/002919fc24a1378347.jpg?3.7.5\"></a>\r\n<a href=\"http://cn.engadget.com/2014/09/18/play-store-material-design-leak/\"><img src=\"/edusoho/web/files/default/2014/09-19/0029255311e3278226.jpg?3.7.5\"></a>\r\n<a href=\"http://cn.engadget.com/2014/09/18/play-store-material-design-leak/\"><img src=\"/edusoho/web/files/default/2014/09-19/002931b87340271391.jpg?3.7.5\"></a>\r\n<a href=\"http://cn.engadget.com/2014/09/18/play-store-material-design-leak/\"><img src=\"/edusoho/web/files/default/2014/09-19/0029360a0426696040.jpg?3.7.5\"></a>', 'home_top_banner', '', '1410920900', '1411057834'), ('2', '1', '清秋主题：首页头部图片轮播', 'html', null, null, '<div class=\"item active\">\n    <img src=\"../themes/autumn/img/slide-1.jpg\">\n</div>\n<div class=\"item\">\n    <img src=\"../themes/autumn/img/slide-2.jpg\">\n</div>\n<div class=\"item\">\n    <img src=\"../themes/autumn/img/slide-3.jpg\">\n</div>', 'autumn:home_top_banner', '', '1410920900', '1410920900'), ('3', '1', '直播频道首页图片轮播', 'html', null, null, '<a href=\"#\"><img src=\"../assets/img/placeholder/live-slide-1.jpg\" /></a>\n<a href=\"#\"><img src=\"../assets/img/placeholder/live-slide-2.jpg\" /></a>', 'live_top_banner', '', '1410920900', '1410920900');
COMMIT;

-- ----------------------------
--  Table structure for `block_history`
-- ----------------------------
DROP TABLE IF EXISTS `block_history`;
CREATE TABLE `block_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编辑区历史记录ID',
  `blockId` int(11) NOT NULL COMMENT '编辑区ID',
  `templateData` text COMMENT '模板历史数据',
  `content` text COMMENT '编辑区历史内容',
  `userId` int(11) NOT NULL COMMENT '编辑区编辑人ID',
  `createdTime` int(11) unsigned NOT NULL COMMENT '编辑区历史记录创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='历史表';

-- ----------------------------
--  Records of `block_history`
-- ----------------------------
BEGIN;
INSERT INTO `block_history` VALUES ('1', '1', null, null, '1', '1410920900'), ('2', '2', null, null, '1', '1410920900'), ('3', '3', null, null, '1', '1410920900'), ('4', '1', null, '<a href=\"\"><img src=\"../assets/img/placeholder/carousel-1200x256-1.png\" /></a>\r\n<a href=\"#\"><img src=\"../assets/img/placeholder/carousel-1200x256-2.png\" /></a>\r\n<a href=\"#\"><img src=\"../assets/img/placeholder/carousel-1200x256-3.png\" /></a>\r\n<img src=\"/edusoho/web/files/default/2014/09-18/2338306e8ce5518461.jpg?3.7.5\">', '1', '1411054736'), ('5', '1', null, '<a href=\"http://cn.engadget.com/2014/09/18/play-store-material-design-leak/\"><img src=\"/edusoho/web/files/default/2014/09-19/002919fc24a1378347.jpg?3.7.5\"></a>\r\n<a href=\"http://cn.engadget.com/2014/09/18/play-store-material-design-leak/\"><img src=\"/edusoho/web/files/default/2014/09-19/0029255311e3278226.jpg?3.7.5\"></a>\r\n<a href=\"http://cn.engadget.com/2014/09/18/play-store-material-design-leak/\"><img src=\"/edusoho/web/files/default/2014/09-19/002931b87340271391.jpg?3.7.5\"></a>\r\n<a href=\"http://cn.engadget.com/2014/09/18/play-store-material-design-leak/\"><img src=\"/edusoho/web/files/default/2014/09-19/0029360a0426696040.jpg?3.7.5\"></a>', '1', '1411057834');
COMMIT;

-- ----------------------------
--  Table structure for `cache`
-- ----------------------------
DROP TABLE IF EXISTS `cache`;
CREATE TABLE `cache` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '缓存ID',
  `name` varchar(128) NOT NULL DEFAULT '' COMMENT '缓存名称',
  `data` longblob COMMENT '缓存数据',
  `serialized` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '缓存是否为序列化的标记位',
  `expiredTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '缓存过期时间',
  `createdTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '缓存创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `expiredTime` (`expiredTime`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `cache`
-- ----------------------------
BEGIN;
INSERT INTO `cache` VALUES ('62', 'settings', 0x613a31313a7b733a343a2261757468223b733a3833383a22613a383a7b733a31333a2272656769737465725f6d6f6465223b733a363a226f70656e6564223b733a32323a22656d61696c5f61637469766174696f6e5f7469746c65223b733a33333a22e8afb7e6bf80e6b4bbe682a8e79a847b7b736974656e616d657d7de5b890e58fb7223b733a32313a22656d61696c5f61637469766174696f6e5f626f6479223b733a3336363a2248692c207b7b6e69636b6e616d657d7d0a0ae6aca2e8bf8ee58aa0e585a57b7b736974656e616d657d7d210a0ae8afb7e782b9e587bbe4b88be99da2e79a84e993bee68ea5e5ae8ce68890e6b3a8e5868cefbc9a0a0a7b7b76657269667975726c7d7d0a0ae5a682e69e9ce4bba5e4b88ae993bee68ea5e697a0e6b395e782b9e587bbefbc8ce8afb7e5b086e4b88ae99da2e79a84e59cb0e59d80e5a48de588b6e588b0e4bda0e79a84e6b58fe8a788e599a828e5a682494529e79a84e59cb0e59d80e6a08fe4b8ade68993e5bc80efbc8ce8afa5e993bee68ea5e59cb0e59d803234e5b08fe697b6e58685e68993e5bc80e69c89e69588e380820a0ae6849fe8b0a2e5afb97b7b736974656e616d657d7de79a84e694afe68c81efbc810a0a7b7b736974656e616d657d7d207b7b7369746575726c7d7d0a0a28e8bf99e698afe4b880e5b081e887aae58aa8e4baa7e7949fe79a84656d61696cefbc8ce8afb7e58bbfe59b9ee5a48de3808229223b733a31353a2277656c636f6d655f656e61626c6564223b733a363a226f70656e6564223b733a31343a2277656c636f6d655f73656e646572223b733a393a22e7868ae58588e7949f223b733a31353a2277656c636f6d655f6d6574686f6473223b613a303a7b7d733a31333a2277656c636f6d655f7469746c65223b733a32343a22e6aca2e8bf8ee58aa0e585a57b7b736974656e616d657d7d223b733a31323a2277656c636f6d655f626f6479223b733a3133383a22e682a8e5a5bd7b7b6e69636b6e616d657d7defbc8ce68891e698af7b7b736974656e616d657d7de79a84e7aea1e79086e59198efbc8ce6aca2e8bf8ee58aa0e585a57b7b736974656e616d657d7defbc8ce7a59de682a8e5ada6e4b9a0e68489e5bfabe38082e5a682e69c89e997aee9a298efbc8ce99a8fe697b6e4b88ee68891e88194e7b3bbe38082223b7d223b733a363a226d61696c6572223b733a3231333a22613a373a7b733a373a22656e61626c6564223b693a303b733a343a22686f7374223b733a31363a22736d74702e6578616d706c652e636f6d223b733a343a22706f7274223b733a323a223235223b733a383a22757365726e616d65223b733a31363a2275736572406578616d706c652e636f6d223b733a383a2270617373776f7264223b733a303a22223b733a343a2266726f6d223b733a31363a2275736572406578616d706c652e636f6d223b733a343a226e616d65223b733a31393a22456475536f686fe7bd91e7bb9ce8afbee5a082223b7d223b733a373a227061796d656e74223b733a3133343a22613a353a7b733a373a22656e61626c6564223b693a303b733a31323a2262616e6b5f67617465776179223b733a343a226e6f6e65223b733a31343a22616c697061795f656e61626c6564223b693a303b733a31303a22616c697061795f6b6579223b733a303a22223b733a31333a22616c697061795f736563726574223b733a303a22223b7d223b733a373a2273746f72616765223b733a3132363a22613a343a7b733a31313a2275706c6f61645f6d6f6465223b733a353a226c6f63616c223b733a31363a22636c6f75645f6163636573735f6b6579223b733a303a22223b733a31323a22636c6f75645f6275636b6574223b733a303a22223b733a31363a22636c6f75645f7365637265745f6b6579223b733a303a22223b7d223b733a363a22726566756e64223b733a3433383a22613a343a7b733a31333a226d6178526566756e6444617973223b693a31303b733a31373a226170706c794e6f74696669636174696f6e223b733a3131383a22e682a8e5a5bdefbc8ce682a8e98080e6acbee79a84e8afbee7a88be4b8ba7b7b636f757273657d7defbc8ce7aea1e79086e59198e5b7b2e694b6e588b0e682a8e79a84e98080e6acbee794b3e8afb7efbc8ce8afb7e88090e5bf83e7ad89e5be85e98080e6acbee5aea1e6a0b8e7bb93e69e9ce38082223b733a31393a22737563636573734e6f74696669636174696f6e223b733a38373a22e682a8e5a5bdefbc8ce682a8e794b3e8afb7e98080e6acbee8afbee7a88b7b7b636f757273657d7d20e5aea1e6a0b8e9809ae8bf87efbc8ce5b086e4b8bae682a8e98080e6acbe7b7b616d6f756e747d7de58583e38082223b733a31383a226661696c65644e6f74696669636174696f6e223b733a39383a22e682a8e5a5bdefbc8ce682a8e794b3e8afb7e98080e6acbee8afbee7a88b7b7b636f757273657d7d20e5aea1e6a0b8e69caae9809ae8bf87efbc8ce8afb7e4b88ee7aea1e79086e59198e5868de58d8fe59586e8a7a3e586b3e7baa0e7bab7e38082223b7d223b733a373a2261727469636c65223b733a36303a22613a323a7b733a343a226e616d65223b733a31323a22e8b584e8aeafe9a291e98193223b733a383a22706167654e756d73223b733a313a2235223b7d223b733a353a227468656d65223b733a3232303a22613a373a7b733a343a226e616d65223b733a31353a22e9bb98e8aea4e4b8bbe9a298284229223b733a363a22617574686f72223b733a31333a22456475536f686fe5ae98e696b9223b733a373a2276657273696f6e223b733a333a22312e30223b733a31353a2273757070726f745f76657273696f6e223b733a343a22312e302b223b733a343a2264617465223b733a31303a22323031332d31312d3037223b733a353a227468756d62223b733a31333a22696d672f7468656d652e6a7067223b733a333a22757269223b733a393a2264656661756c742d62223b7d223b733a383a225f6170705f636f70223b733a343a22693a313b223b733a343a2273697465223b733a3431323a22613a31333a7b733a343a226e616d65223b733a32333a225669676f72e59ca8e7babfe59fb9e8aeade5b9b3e58fb0223b733a363a22736c6f67616e223b733a31383a22e6b1bde8bda6e592a8e8afa2e4b893e5aeb6223b733a333a2275726c223b733a303a22223b733a343a226c6f676f223b733a303a22223b733a373a2266617669636f6e223b733a303a22223b733a31323a2273656f5f6b6579776f726473223b733a363a22e58a9be6b4bb223b733a31353a2273656f5f6465736372697074696f6e223b733a33363a22e4b88ae6b5b7e58a9be6b4bbe4bfa1e681afe68a80e69cafe69c89e99990e585ace58fb8223b733a31323a226d61737465725f656d61696c223b733a31383a226a6176615f7261696e79403132362e636f6d223b733a393a22636f70797269676874223b733a393a22e7868ae58588e7949f223b733a333a22696370223b733a303a22223b733a393a22616e616c7974696373223b733a303a22223b733a363a22737461747573223b733a343a226f70656e223b733a31313a22636c6f7365645f6e6f7465223b733a303a22223b7d223b733a363a22636f75727365223b733a3635333a22613a31333a7b733a32333a2277656c636f6d655f6d6573736167655f656e61626c6564223b733a313a2231223b733a32303a2277656c636f6d655f6d6573736167655f626f6479223b733a34313a227b7b6e69636b6e616d657d7d2ce6aca2e8bf8ee58aa0e585a5e8afbee7a88b7b7b636f757273657d7d223b733a31373a226275795f66696c6c5f75736572696e666f223b733a313a2230223b733a32323a2275736572696e666f4669656c644e616d654172726179223b613a393a7b693a303b733a383a22747275656e616d65223b693a313b733a363a226d6f62696c65223b693a323b733a323a227171223b693a333b733a373a22636f6d70616e79223b693a343b733a333a226a6f62223b693a353b733a363a2267656e646572223b693a363b733a363a22696463617264223b693a373b733a353a22776569626f223b693a383b733a363a2277656978696e223b7d733a32303a22746561636865725f6d6f646966795f7072696365223b733a313a2231223b733a32323a22746561636865725f6d616e6167655f73747564656e74223b733a313a2230223b733a32323a22746561636865725f6578706f72745f73747564656e74223b733a313a2230223b733a32323a2273747564656e745f646f776e6c6f61645f6d65646961223b733a313a2230223b733a31343a2272656c61746564436f7572736573223b733a313a2230223b733a32313a22616c6c6f77416e6f6e796d6f757350726576696577223b733a313a2231223b733a31393a226c6976655f636f757273655f656e61626c6564223b733a313a2230223b733a32313a226c6976655f73747564656e745f6361706163697479223b693a303b733a31343a2275736572696e666f4669656c6473223b613a303a7b7d7d223b733a31353a225f6170705f6c6173745f636865636b223b733a31333a22693a313432373432303336363b223b7d, '1', '0', '1427420366');
COMMIT;

-- ----------------------------
--  Table structure for `category`
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类ID',
  `code` varchar(64) NOT NULL DEFAULT '' COMMENT '分类编码',
  `name` varchar(255) NOT NULL COMMENT '分类名称',
  `icon` varchar(255) NOT NULL DEFAULT '' COMMENT '图标',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT '分类完整路径',
  `weight` int(11) NOT NULL DEFAULT '0' COMMENT '分类权重',
  `groupId` int(10) unsigned NOT NULL COMMENT '分类组ID',
  `parentId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父分类ID',
  `description` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uri` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `category_group`
-- ----------------------------
DROP TABLE IF EXISTS `category_group`;
CREATE TABLE `category_group` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类组ID',
  `code` varchar(64) NOT NULL COMMENT '分类组编码',
  `name` varchar(255) NOT NULL COMMENT '分类组名称',
  `depth` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '该组下分类允许的最大层级数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `category_group`
-- ----------------------------
BEGIN;
INSERT INTO `category_group` VALUES ('1', 'course', '课程分类', '2');
COMMIT;

-- ----------------------------
--  Table structure for `cloud_app`
-- ----------------------------
DROP TABLE IF EXISTS `cloud_app`;
CREATE TABLE `cloud_app` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '云应用ID',
  `name` varchar(255) NOT NULL COMMENT '云应用名称',
  `code` varchar(64) NOT NULL COMMENT '云应用编码',
  `description` text NOT NULL COMMENT '云应用描述',
  `icon` varchar(255) NOT NULL COMMENT '云应用图标',
  `version` varchar(32) NOT NULL COMMENT '云应用当前版本',
  `fromVersion` varchar(32) NOT NULL DEFAULT '0.0.0' COMMENT '云应用更新前版本',
  `developerId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '云应用开发者用户ID',
  `developerName` varchar(255) NOT NULL DEFAULT '' COMMENT '云应用开发者名称',
  `installedTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '云应用安装时间',
  `updatedTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '云应用最后更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='已安装的应用';

-- ----------------------------
--  Records of `cloud_app`
-- ----------------------------
BEGIN;
INSERT INTO `cloud_app` VALUES ('1', 'EduSoho主系统', 'MAIN', '<p>EduSoho主系统</p>\r\n', 'MAIN/MAIN_icon.png', '3.7.5', '3.7.4', '1', 'EduSoho官方', '1410920945', '1411053543');
COMMIT;

-- ----------------------------
--  Table structure for `cloud_app_logs`
-- ----------------------------
DROP TABLE IF EXISTS `cloud_app_logs`;
CREATE TABLE `cloud_app_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '云应用运行日志ID',
  `code` varchar(32) NOT NULL DEFAULT '' COMMENT '应用编码',
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '应用名称',
  `fromVersion` varchar(32) DEFAULT NULL COMMENT '升级前版本',
  `toVersion` varchar(32) NOT NULL DEFAULT '' COMMENT '升级后版本',
  `type` enum('install','upgrade') NOT NULL DEFAULT 'install' COMMENT '升级类型',
  `dbBackupPath` varchar(255) NOT NULL DEFAULT '' COMMENT '数据库备份文件',
  `sourceBackupPath` varchar(255) NOT NULL DEFAULT '' COMMENT '源文件备份地址',
  `status` varchar(32) NOT NULL COMMENT '升级状态(ROLLBACK,ERROR,SUCCESS,RECOVERED)',
  `userId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
  `ip` varchar(32) NOT NULL DEFAULT '' COMMENT 'IP',
  `message` text COMMENT '失败原因',
  `createdTime` int(10) unsigned NOT NULL COMMENT '日志记录时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='应用升级日志';

-- ----------------------------
--  Records of `cloud_app_logs`
-- ----------------------------
BEGIN;
INSERT INTO `cloud_app_logs` VALUES ('1', 'MAIN', 'EduSoho主系统', '3.7.4', '3.7.5', 'upgrade', '', '', 'SUCCESS', '1', '::1', '', '1411053543');
COMMIT;

-- ----------------------------
--  Table structure for `comment`
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `objectType` varchar(32) NOT NULL,
  `objectId` int(10) unsigned NOT NULL,
  `userId` int(10) unsigned NOT NULL DEFAULT '0',
  `content` text NOT NULL,
  `createdTime` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `objectType` (`objectType`,`objectId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `content`
-- ----------------------------
DROP TABLE IF EXISTS `content`;
CREATE TABLE `content` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '内容ID',
  `title` varchar(255) NOT NULL COMMENT '内容标题',
  `editor` enum('richeditor','none') NOT NULL DEFAULT 'richeditor' COMMENT '编辑器选择类型字段',
  `type` varchar(255) NOT NULL COMMENT '内容类型',
  `alias` varchar(255) NOT NULL DEFAULT '' COMMENT '内容别名',
  `summary` text COMMENT '内容摘要',
  `body` text COMMENT '内容正文',
  `picture` varchar(255) NOT NULL DEFAULT '' COMMENT '内容头图',
  `template` varchar(255) NOT NULL DEFAULT '' COMMENT '内容模板',
  `status` enum('published','unpublished','trash') NOT NULL COMMENT '内容状态',
  `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '内容分类ID',
  `tagIds` tinytext COMMENT '内容标签ID',
  `hits` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '内容点击量',
  `featured` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '是否头条',
  `promoted` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否推荐',
  `sticky` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否置顶',
  `userId` int(10) unsigned NOT NULL COMMENT '发布人ID',
  `field1` text COMMENT '扩展字段',
  `field2` text COMMENT '扩展字段',
  `field3` text COMMENT '扩展字段',
  `field4` text COMMENT '扩展字段',
  `field5` text COMMENT '扩展字段',
  `field6` text COMMENT '扩展字段',
  `field7` text COMMENT '扩展字段',
  `field8` text COMMENT '扩展字段',
  `field9` text COMMENT '扩展字段',
  `field10` text COMMENT '扩展字段',
  `publishedTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间',
  `createdTime` int(10) unsigned NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `content`
-- ----------------------------
BEGIN;
INSERT INTO `content` VALUES ('1', '关于我们', 'richeditor', 'page', 'aboutus', null, '', '', 'default', 'published', '0', null, '0', '0', '0', '0', '1', null, null, null, null, null, null, null, null, null, null, '1410920900', '1410920900'), ('2', '常见问题', 'richeditor', 'page', 'questions', null, '', '', 'default', 'published', '0', null, '0', '0', '1', '0', '1', null, null, null, null, null, null, null, null, null, null, '1410920900', '1410920900'), ('3', '培训管理', 'richeditor', 'page', 'management', null, '', '', 'default', 'published', '0', null, '0', '0', '0', '0', '1', null, null, null, null, null, null, null, null, null, null, '1411054612', '1411054638'), ('4', '学习小组', 'richeditor', 'page', 'group', null, '', '', 'default', 'published', '0', null, '0', '0', '0', '0', '1', null, null, null, null, null, null, null, null, null, null, '1411056236', '1411056247');
COMMIT;

-- ----------------------------
--  Table structure for `course`
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '课程ID',
  `title` varchar(1024) NOT NULL COMMENT '课程标题',
  `subtitle` varchar(1024) NOT NULL DEFAULT '' COMMENT '课程副标题',
  `status` enum('draft','published','closed') NOT NULL DEFAULT 'draft' COMMENT '课程状态',
  `type` varchar(255) NOT NULL DEFAULT 'normal' COMMENT '课程类型',
  `maxStudentNum` int(11) NOT NULL DEFAULT '0' COMMENT '直播课程最大学员数上线',
  `price` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '课程价格',
  `expiryDay` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '课程过期天数',
  `showStudentNumType` enum('opened','closed') NOT NULL DEFAULT 'opened' COMMENT '学员数显示模式',
  `serializeMode` enum('none','serialize','finished') NOT NULL DEFAULT 'none' COMMENT '连载模式',
  `income` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '课程销售总收入',
  `lessonNum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '课时数',
  `giveCredit` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '学完课程所有课时，可获得的总学分',
  `rating` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排行分数',
  `ratingNum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '投票人数',
  `vipLevelId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '可以免费看的，会员等级',
  `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分类ID',
  `tags` text COMMENT '标签IDs',
  `smallPicture` varchar(255) NOT NULL DEFAULT '' COMMENT '小图',
  `middlePicture` varchar(255) NOT NULL DEFAULT '' COMMENT '中图',
  `largePicture` varchar(255) NOT NULL DEFAULT '' COMMENT '大图',
  `about` text COMMENT '简介',
  `teacherIds` text COMMENT '显示的课程教师IDs',
  `goals` text COMMENT '课程目标',
  `audiences` text COMMENT '适合人群',
  `recommended` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否为推荐课程',
  `recommendedSeq` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '推荐序号',
  `recommendedTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '推荐时间',
  `locationId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上课地区ID',
  `address` varchar(255) NOT NULL DEFAULT '' COMMENT '上课地区地址',
  `studentNum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '学员数',
  `hitNum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '查看次数',
  `userId` int(10) unsigned NOT NULL COMMENT '课程发布人ID',
  `createdTime` int(10) unsigned NOT NULL COMMENT '课程创建时间',
  `freeStartTime` int(10) NOT NULL DEFAULT '0',
  `freeEndTime` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `course`
-- ----------------------------
BEGIN;
INSERT INTO `course` VALUES ('1', '如何成为一名合格的程序员', '程序员初级入门课程', 'published', 'normal', '0', '0.00', '30', 'opened', 'none', '0.00', '5', '0', '5', '1', '0', '0', '', 'public://course/2014/12-24/213717daaa6e245477.jpg', 'public://course/2014/12-24/213717da8db7039793.jpg', 'public://course/2014/12-24/213717d94689097699.jpg', '<p>\n	<strong>拖延症”这个名词近些年很火，似乎每个人都觉得自己的效率不高，很难集中注意力做好手头的事，那我们究竟该如何提高自己的工作效率呢，大牛来告诉你.</strong>\n</p>\n<p>\n	Aaron Swartz写过一篇很有名的文章，叫做\"<a href=\"http://www.aaronsw.com/weblog/productivity\">HOWTO: Be more productive\"</a>，这篇文章写的实在是太好了，我看了好多遍，很赞同作者的观点。我借鉴了作者提到的一些方法并运用到自己的生活中，发现确实有效果，所以我愿意让更多的人看到这篇文章。<a href=\"http://www.aaronsw.com/\">Aaron Swartz</a>这个人绝对是大牛人，他14时就参与了RSS1.0的制定，他在Stanford读了一年就主动退学了，成为了YC的一员，他的公司后来与reddit合并了，他还是web.py框架的创始人。<br />\n废话少说，下面就是译文:<br />\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br />\n肯定有人跟你说过这样的话“你有看电视的那么长时间，都可以用来写一本书了”，不可否认写书肯定比看电视更好的利用了时间，但是这个结论的成立需要一个假设:\"时间是可互换的\"，也就是说看电视的时间可以轻松的用来写书。但是很遗憾，事实并非如此。\n</p>', '|1|', '|成为一名合格的程序员|', '|不合格的程序员|', '0', '0', '0', '0', '', '1', '20', '1', '1419427974', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `course_announcement`
-- ----------------------------
DROP TABLE IF EXISTS `course_announcement`;
CREATE TABLE `course_announcement` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '课程公告ID',
  `userId` int(10) NOT NULL COMMENT '公告发布人ID',
  `courseId` int(10) NOT NULL COMMENT '公告所属课程ID',
  `content` text NOT NULL COMMENT '公告内容',
  `createdTime` int(10) NOT NULL COMMENT '公告创建时间',
  `updatedTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公告最后更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `course_announcement`
-- ----------------------------
BEGIN;
INSERT INTO `course_announcement` VALUES ('1', '1', '1', '发送系统通知', '1411053139', '0'), ('2', '3', '2', '阿柯也能发公告', '1411105852', '0');
COMMIT;

-- ----------------------------
--  Table structure for `course_chapter`
-- ----------------------------
DROP TABLE IF EXISTS `course_chapter`;
CREATE TABLE `course_chapter` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '课程章节ID',
  `courseId` int(10) unsigned NOT NULL COMMENT '章节所属课程ID',
  `type` enum('chapter','unit') NOT NULL DEFAULT 'chapter' COMMENT '章节类型：chapter为章节，unit为单元。',
  `parentId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'parentId大于０时为单元',
  `number` int(10) unsigned NOT NULL COMMENT '章节编号',
  `seq` int(10) unsigned NOT NULL COMMENT '章节序号',
  `title` varchar(255) NOT NULL COMMENT '章节名称',
  `createdTime` int(10) unsigned NOT NULL COMMENT '章节创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `course_favorite`
-- ----------------------------
DROP TABLE IF EXISTS `course_favorite`;
CREATE TABLE `course_favorite` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '收藏ID',
  `courseId` int(10) unsigned NOT NULL COMMENT '收藏课程的ID',
  `userId` int(10) unsigned NOT NULL COMMENT '收藏人的ID',
  `createdTime` int(10) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户的收藏数据表';

-- ----------------------------
--  Table structure for `course_lesson`
-- ----------------------------
DROP TABLE IF EXISTS `course_lesson`;
CREATE TABLE `course_lesson` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '课时ID',
  `courseId` int(10) unsigned NOT NULL COMMENT '课时所属课程ID',
  `chapterId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '课时所属章节ID',
  `number` int(10) unsigned NOT NULL COMMENT '课时编号',
  `seq` int(10) unsigned NOT NULL COMMENT '课时在课程中的序号',
  `free` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否为免费课时',
  `status` enum('unpublished','published') NOT NULL DEFAULT 'published' COMMENT '课时状态',
  `title` varchar(255) NOT NULL COMMENT '课时标题',
  `summary` text COMMENT '课时摘要',
  `tags` text COMMENT '课时标签',
  `type` varchar(64) NOT NULL DEFAULT 'text' COMMENT '课时类型',
  `content` text COMMENT '课时正文',
  `giveCredit` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '学完课时获得的学分',
  `requireCredit` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '学习课时前，需达到的学分',
  `mediaId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '媒体文件ID',
  `mediaSource` varchar(32) NOT NULL DEFAULT '' COMMENT '媒体文件来源(self:本站上传,youku:优酷)',
  `mediaName` varchar(255) NOT NULL DEFAULT '' COMMENT '媒体文件名称',
  `mediaUri` text COMMENT '媒体文件资源名',
  `length` int(11) unsigned DEFAULT NULL COMMENT '时长',
  `materialNum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上传的资料数量',
  `quizNum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '测验题目数量',
  `learnedNum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '已学的学员数',
  `viewedNum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '查看数',
  `startTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '直播课时开始时间',
  `endTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '直播课时结束时间',
  `memberNum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '直播课时加入人数',
  `replayStatus` enum('ungenerated','generating','generated') NOT NULL DEFAULT 'ungenerated',
  `userId` int(10) unsigned NOT NULL COMMENT '发布人ID',
  `createdTime` int(10) unsigned NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `course_lesson`
-- ----------------------------
BEGIN;
INSERT INTO `course_lesson` VALUES ('1', '1', '0', '1', '1', '1', 'published', '程序员学习第一课', '肯定有人跟你说过这样的话“你有看电视的那么长时间，都可以用来写一本书了”，不可否认写书肯定比看电视更好的利用了时间，但是这个结论的成立需要一个假设:\"时间是可互换的\"，也就是说看电视的时间可以轻松的用来写书。但是很遗憾，事实并非如此。\r\n不同的时间有不同的质量等级。如果我在走向地铁站的路上发现自己的笔记本忘带了，我就很难集中注意力写文章。同样，当你不停的被打断的时候，你也很难集中注意力。这里还有一些心理和情感上的因素，有的时候我心情很好，愿意主动去做一些事，但还有一些时候我感到很抑郁和疲惫，就只能看看电视了。\r\n如果你想变的更加有效率，你必须意识到这个事实，并且很好的处理它。首先，你必须很好的利用不同种类的时间。其次，你必须让你的时间更有效率。', null, 'text', '<p>\r\n	<strong>更有效的利用你的时间</strong>\r\n</p>\r\n<p>\r\n	<strong>选择合适的问题</strong>\r\n</p>\r\n<p>\r\n	生命是如此的短暂，为什么浪费时间做一些没意义的事呢？做一些让你感到舒适的事很容易，但是你应该问问自己为什么要做这些事呢？有没有一些更重要的事等着你去做？为什么你不去做那些事呢？这些问题很难回答，但是每解决一个都会让你更有效率。<br />\r\n这不是说你所有的时间都应该用来做那些最重要的事。我的时间就肯定不是这样(否则，我现在就不会在写这篇文章了)。但是，这是我衡量自己的生活是否充实的重要标准。\r\n</p>\r\n<p>\r\n	<strong>收集很多问题</strong>\r\n</p>\r\n<p>\r\n	另一个很多人都知道的秘密是：如果你认准一个问题，投入全部精力去解决它，这样你的效率是最高的。我发现这却是很难实现的。以现在为例，我正在锻炼身体，喝橙汁，整理桌面，和我弟弟聊天，同时在写现在这篇文章。今天一整天，我写了现在这篇文章，读了一本书，吃了点东西，回复了几封邮件，和一些朋友聊了聊天，买了点东西，改了改其他几篇文章，备份了硬盘，还整理了一下图书列表。<br />\r\n有很多不同的项目让我能够在不同质量的时间下做不同的工作。更重要的是，在你卡壳或是厌烦的时候有其他的一些事可以做。<br />\r\n这同时会让你变得更加有创造力。创造力就是你把自己从其他地方学到的东西能够用到你的工作中。如果你同时做许多不同方向的工作，那你就会得到更多的想法和创意。\r\n</p>', '0', '0', '0', '', '', '', null, '1', '0', '0', '0', '0', '0', '0', 'ungenerated', '1', '1419428459'), ('2', '1', '0', '2', '2', '0', 'published', '程序员学习第二课', '肯定有人跟你说过这样的话“你有看电视的那么长时间，都可以用来写一本书了”，不可否认写书肯定比看电视更好的利用了时间，但是这个结论的成立需要一个假设:\"时间是可互换的\"，也就是说看电视的时间可以轻松的用来写书。但是很遗憾，事实并非如此。\r\n不同的时间有不同的质量等级。如果我在走向地铁站的路上发现自己的笔记本忘带了，我就很难集中注意力写文章。同样，当你不停的被打断的时候，你也很难集中注意力。这里还有一些心理和情感上的因素，有的时候我心情很好，愿意主动去做一些事，但还有一些时候我感到很抑郁和疲惫，就只能看看电视了。\r\n如果你想变的更加有效率，你必须意识到这个事实，并且很好的处理它。首先，你必须很好的利用不同种类的时间。其次，你必须让你的时间更有效率。', null, 'text', '<p>\r\n	<strong>列一个清单</strong>\r\n</p>\r\n<p>\r\n	找一些不同的事同时做并不困难，大部分人都有很多很多的待办事项。但是如果你想把它们全记在脑袋里的话，它们就会慢慢消失。要记住所有这些事所给你带来的心智上的压力会把你压垮。解决办法仍然是很简单：把它们写下来。<br />\r\n一旦你把要做的事列成了一个清单，你就可以更好的分类组织它们了。比如说，我的清单包括：编程，思考，差事，读书，娱乐休息。<br />\r\n大部分项目都包括很多不同的任务。以写这篇文章为例，除了真正的写作过程，还包括了阅读其他关于拖沓的文章，考虑文章的各个部分，整理语句，向别人请教问题等等。每一项任务都属于清单的不同部分，所以你可以在合适的时间才去做某一部分。\r\n</p>\r\n<p>\r\n	<strong>把任务清单和你的生活结合起来</strong>\r\n</p>\r\n<p>\r\n	一旦你有了这样一个任务清单，你需要做的事就是时常记得它，而记住它的最好方法是把它放在你能看到的地方。比如说，我总在我桌子上放一摞书，最上面的那一本就是我最近在读的。当我想要读书的时候，我就直接从上面拿一本书来读。<br />\r\n对于看电视/电影我也这么做。当我对某一个电影感兴趣的时候，我会把它放在电脑中一个特殊的文件夹内。每当我想休息一下，看看电影的时候，我就会打开那个文件夹。<br />\r\n我也想过一些更深入的方式，比如说我把一些想看的文章标记为\"待读\"(to read)，当我想要上网的时候就看看那些从前积累下来的未读文章。\r\n</p>', '0', '0', '0', '', '', '', null, '0', '0', '0', '0', '0', '0', '0', 'ungenerated', '1', '1419428507'), ('3', '1', '0', '3', '3', '0', 'published', '程序员学习第三课', '肯定有人跟你说过这样的话“你有看电视的那么长时间，都可以用来写一本书了”，不可否认写书肯定比看电视更好的利用了时间，但是这个结论的成立需要一个假设:\"时间是可互换的\"，也就是说看电视的时间可以轻松的用来写书。但是很遗憾，事实并非如此。\r\n不同的时间有不同的质量等级。如果我在走向地铁站的路上发现自己的笔记本忘带了，我就很难集中注意力写文章。同样，当你不停的被打断的时候，你也很难集中注意力。这里还有一些心理和情感上的因素，有的时候我心情很好，愿意主动去做一些事，但还有一些时候我感到很抑郁和疲惫，就只能看看电视了。\r\n如果你想变的更加有效率，你必须意识到这个事实，并且很好的处理它。首先，你必须很好的利用不同种类的时间。其次，你必须让你的时间更有效率。', null, 'text', '<p>\r\n	<strong>提高你时间的质量</strong>\r\n</p>\r\n<p>\r\n	像上面那样最大限度的利用时间还远远不够，更重要的是提高你自己的时间的质量。那你究竟该怎样做呢？\r\n</p>\r\n<p>\r\n	<strong>减轻身体上的约束</strong>\r\n</p>\r\n<p>\r\n	<strong>携带纸和笔</strong>\r\n</p>\r\n<p>\r\n	我认识的很多人的口袋里都有记事簿之类的东西。纸和笔在很多时候都是非常有用的，你可以随时随刻的记录自己的想法，我甚至通过这种方法在地铁上写过整篇文章。\r\n</p>\r\n<p>\r\n	<strong>避免被打扰</strong>\r\n</p>\r\n<p>\r\n	对于那些需要集中注意力的任务，你应该尽量避免被打扰。一个很简单的方法是去一个没人能打扰你的地方，另一个方法是告诉周围的人未来一段时间不要打扰你。<br />\r\n关于这点不要过犹不及。当你在浪费时间的时候你反倒应该被打扰一下，帮助别人解决问题肯定比坐在那里看新闻更好的利用了时间。\r\n</p>\r\n<p>\r\n	<strong>减轻心理上的约束</strong>\r\n</p>\r\n<p>\r\n	<strong>吃，睡，运动</strong>\r\n</p>\r\n<p>\r\n	当你感到很饿，很累，很焦躁的时候，你的时间的质量会很低。解决这个问题很简单，就是：去吃，去睡，去运动。对自己说“虽然我很累了，但我不能休息，因为我必须要工作”会让你感到自己很努力，但事实上休息之后你的效率会更高。既然你迟早都要睡觉，还不如先休息好，来提高剩余时间内的效率。\r\n</p>', '0', '0', '0', '', '', '', null, '0', '0', '0', '0', '0', '0', '0', 'ungenerated', '1', '1419428535'), ('4', '1', '0', '4', '4', '0', 'published', '程序员学习第四课', '第四课摘要', null, 'text', '<p>\r\n	<strong>与快乐的人相处</strong>\r\n</p>\r\n<p>\r\n	跟快乐的人相处会也会让你变得快乐，也会让你心态更放松。也许很多人愿意躲在屋子里，不与其他人接触，埋头干活，他们觉得这样的话时间才没有被“浪费”，但事实上这会让他们变得情绪低落，工作效率也会大大下降。\r\n</p>\r\n<p>\r\n	<strong>与朋友分担你的压力</strong>\r\n</p>\r\n<p>\r\n	即使你的朋友并不是能够感染他人，给你带来快乐的那种人，和其他的人一起解决复杂的问题也会让问题变得简单。一方面，精神上的压力大家可以互相分担，另一方面，和其他人在一起可以让你专注于工作而不是时常分心。\r\n</p>\r\n<p>\r\n	<strong>拖沓</strong>\r\n</p>\r\n<p>\r\n	上面所说的那些并不是问题的重点，关于效率大家最大的问题还是“拖沓”。虽然很多人不承认，但是几乎所有人都或多或少的会拖沓。那又该如何避免呢？<br />\r\n拖沓是什么？从旁观者来看，你在做好玩的事(如玩游戏，看新闻)而不是做真正的工作。但问题的关键是：你究竟为什么会这样？你的脑子里究竟是怎么想的？<br />\r\n我花了很多时间来研究这件事，我能给出的最好解释是在你的大脑赋予“脑力场”给每一项任务。你玩过两块磁铁相互作用吗？如果你让它们异极相对，他们就会相互排斥，你会感到他们之间的磁场力。你越是想要把它们和在一起，越会感到它们之间的排斥力。<br />\r\n心智和精神上也是类似的。它是看不见摸不着的，但你却可以感受到它的存在。并且你越是想要接近它，它会离你越远。<br />\r\n你不可能通过蛮力来克服两个场之间的排斥力，相反，你应该做的是调转方向。<br />\r\n那又是什么产生了“精神力场”呢？似乎有两个主要原因：任务是否艰巨，任务是否是被指派的。\r\n</p>\r\n<p>\r\n	<strong>艰巨的任务</strong>\r\n</p>\r\n<p>\r\n	<strong>把任务细分</strong>\r\n</p>\r\n<p>\r\n	一个任务很艰巨的原因之一是这个任务很宏大。比如说你想要做一个菜谱构造程序，没有人能一下子完成它，这是一个目标而不是一项任务。一项任务是使你能够朝向目标更进一步的具体概念。一个好的任务是你能够立即拿来实施的，比如\"画一个展示菜谱的草图\"。<br />\r\n当你完成了上一个任务后，下一步就会变得更加清晰。你将会考虑一个菜谱有什么构成，你需要什么样的搜索机制，如何构建菜谱的数据库，等等。这样你就构建了一个引擎，每一个任务都会通向下一个任务。<br />\r\n对于每一个比较大的项目，我都会考虑我需要完成一连串什么样的任务，并且将这些任务加入到我的待办事项列表中去。同样，当我做完一些任务之后我会把接下来需要完成的任务再加入任务列表中去。\r\n</p>', '0', '0', '0', '', '', '', null, '0', '0', '0', '0', '0', '0', '0', 'ungenerated', '1', '1419428568'), ('5', '1', '0', '5', '5', '0', 'published', '程序员学习第五课', '第五课摘要', null, 'text', '<p>\r\n	<strong>简化任务</strong>\r\n</p>\r\n<p>\r\n	另一个让任务变得艰巨的原因就是它太复杂了。\"写一本书\"这个任务会放你感到无从下手，那么就先从写一篇文章开始吧。如果一篇文章也觉得太多了，那么就先写一个段落的概要吧。最重要的是真正做了一些工作，真正的有进展。<br />\r\n一旦你明确了你的任务之后，你就可以更清楚的判断它，更容易的理解它。提高完善一些已有的东西比从头创建东西更容易。如果你的一个段落写好了，那么一点一点积累，它会变成一篇文章，最终变成一本书。\r\n</p>\r\n<p>\r\n	<strong>认真考虑它</strong>\r\n</p>\r\n<p>\r\n	通常来说解决一个困难问题需要一些灵感。如果你对那个领域并不熟悉，你应该从研究这个领域开始，借鉴一下其他人的经验，慢慢的研究理解这个领域，并且做一些小的尝试看看你能否搞定这个领域。\r\n</p>\r\n<p>\r\n	<strong>被指派的任务</strong>\r\n</p>\r\n<p>\r\n	被指派的任务是那些你被要求完成的任务。很多心理学实验都表明:当你\"刺激\"其他人做什么事的时候，他们反倒不容易做好那个事。奖励，惩罚等外部刺激会扼杀\"内在动机\"--你对于某个问题发自内心的兴趣。人类的大脑对于被要求做的事有先天的抗拒力。<br />\r\n这种现象不仅局限于其他人要求你做的事，当你向自己分配任务时仍然会出现这种现象。如果你对自己说\"我应该好好做X工作了，这是我现在最重要的事\"，之后你就会感到X突然变成了世界上最困难的事情了。然而一旦当Y变成了\"最重要的事\"，原来的那个X又变得简单了。\r\n</p>\r\n<p>\r\n	<strong>虚构一个任务</strong>\r\n</p>\r\n<p>\r\n	如果你要完成X，那就告诉自己做Y。然而不幸的是，这样欺骗自己却很难，因为你清楚你究竟要做什么。\r\n</p>\r\n<p>\r\n	<strong>不要自己给自己布置任务</strong>\r\n</p>\r\n<p>\r\n	给自己布置任务看起来很诱人，比如对自己说\"我要写完这篇文章才去吃饭\"，更糟糕的是让别人假装布置给你一些任务。但是这两种方式都会让你变得更没有效率，事实上你还是在给自己布置任务，你的大脑只会去逃避它。\r\n</p>\r\n<p>\r\n	<strong>把事情变得有趣</strong>\r\n</p>\r\n<p>\r\n	困难的工作听起来不会令人感到愉悦，但事实上这可能就是最能让我感到高兴的事。一个困难的问题不但能让你集中全部注意力，而且当你完成它的时候你会感到非常棒，非常有成就感。<br />\r\n所以帮助自己完成一件事的秘密不是说服自己必须完成它，而是说服自己这件事确实非常有意思。如果一件事没有意思的话，你需要做的就是让它变得有意思\r\n</p>\r\n<p>\r\n	<strong>总结</strong>\r\n</p>\r\n<p>\r\n	效率的真正秘密在于\"聆听自己\"，在你饿的时候吃饭，在你疲惫的时候睡觉，当你厌烦的时候休息一下，做那些有趣好玩的项目。<br />\r\n这看起来很容易，但是社会上的一些观念正在把我们向相反的方向引导。要想变得更加有效率，我们需要做的就是转过头来\"聆听自己\"<a href=\"http://images.cnblogs.com/cnblogs_com/meng-meng/201111/20111117102128284.gif\"><img alt=\"clip_image001\" border=\"0\" height=\"2\" style=\"height:auto;\" title=\"clip_image001\" width=\"2\" src=\"cid:5db818d452f5fd1511ca71cce522a16f\" id=\"en-media:image/gif:5db818d452f5fd1511ca71cce522a16f:2:2\" /></a>\r\n</p>', '0', '0', '0', '', '', '', null, '0', '0', '0', '0', '0', '0', '0', 'ungenerated', '1', '1419428591');
COMMIT;

-- ----------------------------
--  Table structure for `course_lesson_learn`
-- ----------------------------
DROP TABLE IF EXISTS `course_lesson_learn`;
CREATE TABLE `course_lesson_learn` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '学员课时学习记录ID',
  `userId` int(10) unsigned NOT NULL COMMENT '学员ID',
  `courseId` int(10) unsigned NOT NULL COMMENT '课程ID',
  `lessonId` int(10) unsigned NOT NULL COMMENT '课时ID',
  `status` enum('learning','finished') NOT NULL COMMENT '学习状态',
  `startTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '学习开始时间',
  `finishedTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '学习完成时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `userId_lessonId` (`userId`,`lessonId`),
  KEY `userId_courseId` (`userId`,`courseId`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `course_lesson_learn`
-- ----------------------------
BEGIN;
INSERT INTO `course_lesson_learn` VALUES ('1', '1', '1', '1', 'finished', '1411038150', '1411038156'), ('2', '1', '1', '4', 'finished', '1411208418', '1411208456'), ('3', '2', '1', '1', 'finished', '1411208576', '1411208578'), ('4', '2', '1', '4', 'finished', '1411208586', '1411208588'), ('5', '2', '1', '5', 'finished', '1411209192', '1411209214'), ('6', '1', '1', '5', 'finished', '1419056637', '1419056654'), ('7', '1', '1', '2', 'learning', '1427294493', '0'), ('8', '1', '1', '3', 'learning', '1427294497', '0'), ('9', '4', '1', '1', 'finished', '1427420702', '1427420705'), ('10', '4', '1', '2', 'finished', '1427420707', '1427420709'), ('11', '4', '1', '3', 'finished', '1427420711', '1427420712'), ('12', '4', '1', '4', 'finished', '1427420714', '1427420715'), ('13', '4', '1', '5', 'finished', '1427420717', '1427420718');
COMMIT;

-- ----------------------------
--  Table structure for `course_lesson_replay`
-- ----------------------------
DROP TABLE IF EXISTS `course_lesson_replay`;
CREATE TABLE `course_lesson_replay` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `lessonId` int(10) unsigned NOT NULL COMMENT '所属课时',
  `courseId` int(10) unsigned NOT NULL COMMENT '所属课程',
  `title` varchar(255) NOT NULL COMMENT '名称',
  `replayId` text NOT NULL COMMENT '云直播中的回放id',
  `userId` int(10) unsigned NOT NULL COMMENT '创建者',
  `createdTime` int(10) unsigned NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `course_lesson_view`
-- ----------------------------
DROP TABLE IF EXISTS `course_lesson_view`;
CREATE TABLE `course_lesson_view` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `courseId` int(10) NOT NULL,
  `lessonId` int(10) NOT NULL,
  `fileId` int(10) NOT NULL,
  `userId` int(10) NOT NULL,
  `fileType` enum('document','video','audio','image','ppt','other') NOT NULL DEFAULT 'other',
  `fileStorage` enum('local','cloud','net') NOT NULL,
  `fileSource` varchar(32) NOT NULL,
  `createdTime` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `course_lesson_view`
-- ----------------------------
BEGIN;
INSERT INTO `course_lesson_view` VALUES ('1', '1', '1', '0', '1', 'video', 'net', 'youku', '1411038150'), ('2', '1', '1', '0', '1', 'video', 'net', 'youku', '1411050441'), ('3', '1', '4', '0', '1', '', 'net', '', '1411208418'), ('4', '1', '1', '0', '2', 'video', 'net', 'youku', '1411208576'), ('5', '1', '4', '0', '2', '', 'net', '', '1411208586'), ('6', '1', '5', '1', '2', '', 'local', '', '1411209192'), ('7', '1', '5', '1', '2', '', 'local', '', '1411209428'), ('8', '1', '1', '0', '2', 'video', 'net', 'youku', '1411289275'), ('9', '1', '5', '1', '1', '', 'local', '', '1419056637'), ('10', '1', '1', '0', '1', '', 'net', '', '1419471864'), ('11', '1', '1', '0', '1', '', 'net', '', '1419481334'), ('12', '1', '5', '0', '1', '', 'net', '', '1427294485'), ('13', '1', '2', '0', '1', '', 'net', '', '1427294493'), ('14', '1', '3', '0', '1', '', 'net', '', '1427294497'), ('15', '1', '4', '0', '1', '', 'net', '', '1427294501'), ('16', '1', '5', '0', '1', '', 'net', '', '1427294503'), ('17', '1', '4', '0', '1', '', 'net', '', '1427294506'), ('18', '1', '3', '0', '1', '', 'net', '', '1427294506'), ('19', '1', '2', '0', '1', '', 'net', '', '1427294507'), ('20', '1', '1', '0', '1', '', 'net', '', '1427294509'), ('21', '1', '1', '0', '4', '', 'net', '', '1427420702'), ('22', '1', '2', '0', '4', '', 'net', '', '1427420707'), ('23', '1', '3', '0', '4', '', 'net', '', '1427420711'), ('24', '1', '4', '0', '4', '', 'net', '', '1427420714'), ('25', '1', '5', '0', '4', '', 'net', '', '1427420717'), ('26', '1', '1', '0', '4', '', 'net', '', '1427422008');
COMMIT;

-- ----------------------------
--  Table structure for `course_material`
-- ----------------------------
DROP TABLE IF EXISTS `course_material`;
CREATE TABLE `course_material` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '课程资料ID',
  `courseId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '资料所属课程ID',
  `lessonId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '资料所属课时ID',
  `title` varchar(1024) NOT NULL COMMENT '资料标题',
  `description` text COMMENT '资料描述',
  `link` varchar(1024) NOT NULL DEFAULT '' COMMENT '外部链接地址',
  `fileId` int(10) unsigned NOT NULL COMMENT '资料文件ID',
  `fileUri` varchar(255) NOT NULL DEFAULT '' COMMENT '资料文件URI',
  `fileMime` varchar(255) NOT NULL DEFAULT '' COMMENT '资料文件MIME',
  `fileSize` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '资料文件大小',
  `userId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '资料创建人ID',
  `createdTime` int(10) unsigned NOT NULL COMMENT '资料创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `course_material`
-- ----------------------------
BEGIN;
INSERT INTO `course_material` VALUES ('1', '1', '1', '长安标致雪铁龙汽车 中欧平台需求 - 20140918.xlsx', '平台需求', '', '2', '', '', '11171', '1', '1419428612');
COMMIT;

-- ----------------------------
--  Table structure for `course_member`
-- ----------------------------
DROP TABLE IF EXISTS `course_member`;
CREATE TABLE `course_member` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '课程学员记录ID',
  `courseId` int(10) unsigned NOT NULL COMMENT '课程ID',
  `userId` int(10) unsigned NOT NULL COMMENT '学员ID',
  `orderId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '学员购买课程时的订单ID',
  `deadline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '学习最后期限',
  `levelId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户以会员的方式加入课程学员时的会员ID',
  `learnedNum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '已学课时数',
  `credit` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '学员已获得的学分',
  `noteNum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '笔记数目',
  `noteLastUpdateTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最新的笔记更新时间',
  `isLearned` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否已学完',
  `seq` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序序号',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `isVisible` tinyint(2) NOT NULL DEFAULT '1' COMMENT '可见与否，默认为可见',
  `role` enum('student','teacher') NOT NULL DEFAULT 'student' COMMENT '课程会员角色',
  `locked` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '学员是否被锁定',
  `createdTime` int(10) unsigned NOT NULL COMMENT '学员加入课程时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `courseId` (`courseId`,`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `course_member`
-- ----------------------------
BEGIN;
INSERT INTO `course_member` VALUES ('1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '1', 'teacher', '0', '1419427974'), ('2', '1', '4', '5', '1430012697', '0', '5', '0', '0', '0', '1', '0', '', '1', 'student', '0', '1427420697');
COMMIT;

-- ----------------------------
--  Table structure for `course_note`
-- ----------------------------
DROP TABLE IF EXISTS `course_note`;
CREATE TABLE `course_note` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '笔记ID',
  `userId` int(10) NOT NULL COMMENT '笔记作者ID',
  `courseId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '课程ID',
  `lessonId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '课时ID',
  `content` text NOT NULL COMMENT '笔记内容',
  `length` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '笔记内容的字数',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '笔记状态：0:私有, 1:公开',
  `createdTime` int(10) NOT NULL COMMENT '笔记创建时间',
  `updatedTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '笔记更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `course_review`
-- ----------------------------
DROP TABLE IF EXISTS `course_review`;
CREATE TABLE `course_review` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '课程评价ID',
  `userId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评价人ID',
  `courseId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '被评价的课程ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '评价标题',
  `content` text NOT NULL COMMENT '评论内容',
  `rating` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评分',
  `createdTime` int(10) unsigned NOT NULL COMMENT '评价创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `course_review`
-- ----------------------------
BEGIN;
INSERT INTO `course_review` VALUES ('1', '4', '1', '', '课程不错,赞一个', '5', '1427421990');
COMMIT;

-- ----------------------------
--  Table structure for `course_thread`
-- ----------------------------
DROP TABLE IF EXISTS `course_thread`;
CREATE TABLE `course_thread` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '课程话题ID',
  `courseId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '话题所属课程ID',
  `lessonId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '话题所属课时ID',
  `userId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '话题发布人ID',
  `type` enum('discussion','question') NOT NULL DEFAULT 'discussion' COMMENT '话题类型',
  `isStick` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否置顶',
  `isElite` tinyint(10) unsigned NOT NULL DEFAULT '0' COMMENT '是否精华',
  `isClosed` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '是否关闭',
  `title` varchar(255) NOT NULL COMMENT '话题标题',
  `content` text COMMENT '话题内容',
  `postNum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '回复数',
  `hitNum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '查看数',
  `followNum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '关注数',
  `latestPostUserId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后回复人ID',
  `latestPostTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后回复时间',
  `createdTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '话题创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `course_thread_post`
-- ----------------------------
DROP TABLE IF EXISTS `course_thread_post`;
CREATE TABLE `course_thread_post` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '课程话题回复ID',
  `courseId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '回复所属课程ID',
  `lessonId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '回复所属课时ID',
  `threadId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '回复所属话题ID',
  `userId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '回复人',
  `isElite` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否精华',
  `content` text NOT NULL COMMENT '正文',
  `createdTime` int(10) unsigned NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `file`
-- ----------------------------
DROP TABLE IF EXISTS `file`;
CREATE TABLE `file` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '上传文件ID',
  `groupId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上传文件组ID',
  `userId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上传人ID',
  `uri` varchar(255) NOT NULL COMMENT '文件URI',
  `mime` varchar(255) NOT NULL COMMENT '文件MIME',
  `size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '文件状态',
  `createdTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件上传时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `file`
-- ----------------------------
BEGIN;
INSERT INTO `file` VALUES ('1', '4', '1', 'public://user/2014/09-17/1029575e51af824196.jpg', '', '10063', '0', '1410920997'), ('2', '4', '1', 'public://user/2014/09-17/1029575ea40f790172.jpg', '', '4425', '0', '1410920997'), ('3', '4', '1', 'public://user/2014/09-17/1029575ebaf8871653.jpg', '', '1533', '0', '1410920997'), ('4', '3', '1', 'public://course/2014/09-17/103715b28f17458333.png', '', '92957', '0', '1410921435'), ('5', '3', '1', 'public://course/2014/09-17/103715b34d0d349483.png', '', '44418', '0', '1410921435'), ('6', '3', '1', 'public://course/2014/09-17/103715b36a51834334.png', '', '6215', '0', '1410921435'), ('7', '4', '1', 'public://user/2014/09-18/231820c50d4c900089.jpg', '', '15713', '0', '1411053500'), ('8', '4', '1', 'public://user/2014/09-18/231820c54849225846.jpg', '', '6598', '0', '1411053500'), ('9', '4', '1', 'public://user/2014/09-18/231820c559be169722.jpg', '', '1823', '0', '1411053500'), ('10', '1', '1', 'public://default/2014/09-18/2338306e8ce5518461.jpg', '', '2533059', '0', '1411054710'), ('11', '1', '1', 'public://default/2014/09-18/234933d1cff7460669.jpg', '', '78686', '0', '1411055373'), ('12', '1', '1', 'public://default/2014/09-18/235140cf2d7f910648.JPG', '', '56861', '0', '1411055500'), ('13', '4', '1', 'public://user/2014/09-19/0001360e3e78771620.jpg', '', '4656', '0', '1411056096'), ('14', '4', '1', 'public://user/2014/09-19/0002091c7bcb672123.jpg', '', '55367', '0', '1411056129'), ('15', '1', '1', 'public://default/2014/09-19/002919fc24a1378347.jpg', '', '181702', '0', '1411057759'), ('16', '1', '1', 'public://default/2014/09-19/0029255311e3278226.jpg', '', '66382', '0', '1411057765'), ('17', '1', '1', 'public://default/2014/09-19/002931b87340271391.jpg', '', '193752', '0', '1411057771'), ('18', '1', '1', 'public://default/2014/09-19/0029360a0426696040.jpg', '', '42776', '0', '1411057776'), ('19', '4', '2', 'public://user/2014/09-19/102636c7d801999730.jpg', '', '15327', '0', '1411093596'), ('20', '4', '2', 'public://user/2014/09-19/102636c81404161605.jpg', '', '6576', '0', '1411093596'), ('21', '4', '2', 'public://user/2014/09-19/102636c82199607128.jpg', '', '1956', '0', '1411093596'), ('22', '3', '1', 'public://course/2014/09-19/104046eafb29879452.jpg', '', '33579', '0', '1411094446'), ('23', '3', '1', 'public://course/2014/09-19/104046eb69ca271406.jpg', '', '16759', '0', '1411094446'), ('24', '3', '1', 'public://course/2014/09-19/104046eb8396075033.jpg', '', '3393', '0', '1411094446'), ('25', '3', '1', 'public://course/2014/12-24/213717d94689097699.jpg', '', '36165', '0', '1419428237'), ('26', '3', '1', 'public://course/2014/12-24/213717da8db7039793.jpg', '', '18706', '0', '1419428237'), ('27', '3', '1', 'public://course/2014/12-24/213717daaa6e245477.jpg', '', '3755', '0', '1419428237');
COMMIT;

-- ----------------------------
--  Table structure for `file_group`
-- ----------------------------
DROP TABLE IF EXISTS `file_group`;
CREATE TABLE `file_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '上传文件组ID',
  `name` varchar(255) NOT NULL COMMENT '上传文件组名称',
  `code` varchar(255) NOT NULL COMMENT '上传文件组编码',
  `public` tinyint(4) NOT NULL DEFAULT '1' COMMENT '文件组文件是否公开',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `file_group`
-- ----------------------------
BEGIN;
INSERT INTO `file_group` VALUES ('1', '默认文件组', 'default', '1'), ('2', '缩略图', 'thumb', '1'), ('3', '课程', 'course', '1'), ('4', '用户', 'user', '1'), ('5', '课程私有文件', 'course_private', '0'), ('6', '资讯', 'article', '1');
COMMIT;

-- ----------------------------
--  Table structure for `friend`
-- ----------------------------
DROP TABLE IF EXISTS `friend`;
CREATE TABLE `friend` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '关注ID',
  `fromId` int(10) unsigned NOT NULL COMMENT '关注人ID',
  `toId` int(10) unsigned NOT NULL COMMENT '被关注人ID',
  `createdTime` int(10) unsigned NOT NULL COMMENT '关注时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `groups`
-- ----------------------------
DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '小组id',
  `title` varchar(100) NOT NULL COMMENT '小组名称',
  `about` text COMMENT '小组介绍',
  `logo` varchar(100) NOT NULL DEFAULT '' COMMENT 'logo',
  `backgroundLogo` varchar(100) NOT NULL DEFAULT '',
  `status` enum('open','close') NOT NULL DEFAULT 'open',
  `memberNum` int(10) unsigned NOT NULL DEFAULT '0',
  `threadNum` int(10) unsigned NOT NULL DEFAULT '0',
  `postNum` int(10) unsigned NOT NULL DEFAULT '0',
  `ownerId` int(10) unsigned NOT NULL COMMENT '小组组长id',
  `createdTime` int(11) unsigned NOT NULL COMMENT '创建小组时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `groups`
-- ----------------------------
BEGIN;
INSERT INTO `groups` VALUES ('1', '人力资源小组', '<p>\n	<span style=\"font-family:\'sans serif\', tahoma, verdana, helvetica;font-size:14px;line-height:1.428571429;\">\n	</span></p><p style=\"font-size:10.1px;font-family:SimSun;\">\n		<strong>人力资源专员这一职位（一个工作职位有多个人，例如人力资源专员有20个人），要求具备沟通能力（有等级描述），不同等级的沟通能力对应了6个课程</strong><span style=\"font-family:\'sans serif\', tahoma, verdana, helvetica;font-size:14px;line-height:1.428571429;\"><strong></strong></span><span style=\"font-family:\'sans serif\', tahoma, verdana, helvetica;font-size:14px;line-height:1.428571429;\"><strong><img src=\"http://localhost/edusoho/web/assets/libs/gallery2/kindeditor/4.1.10/plugins/emoticons/images/13.gif\" border=\"0\" alt=\"\" /></strong></span>\n	</p>\n\n', 'public://user/2014/09-19/0001360e3e78771620.jpg', 'public://user/2014/09-19/0002091c7bcb672123.jpg', 'open', '1', '0', '0', '1', '1411056049');
COMMIT;

-- ----------------------------
--  Table structure for `groups_member`
-- ----------------------------
DROP TABLE IF EXISTS `groups_member`;
CREATE TABLE `groups_member` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '成员id主键',
  `groupId` int(10) unsigned NOT NULL COMMENT '小组id',
  `userId` int(10) unsigned NOT NULL COMMENT '用户id',
  `role` varchar(100) NOT NULL DEFAULT 'member',
  `postNum` int(10) unsigned NOT NULL DEFAULT '0',
  `threadNum` int(10) unsigned NOT NULL DEFAULT '0',
  `createdTime` int(11) unsigned NOT NULL COMMENT '加入时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `groups_member`
-- ----------------------------
BEGIN;
INSERT INTO `groups_member` VALUES ('1', '1', '1', 'owner', '0', '0', '1411056049');
COMMIT;

-- ----------------------------
--  Table structure for `groups_thread`
-- ----------------------------
DROP TABLE IF EXISTS `groups_thread`;
CREATE TABLE `groups_thread` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '话题id',
  `title` varchar(1024) NOT NULL COMMENT '话题标题',
  `content` text COMMENT '话题内容',
  `isElite` int(11) unsigned NOT NULL DEFAULT '0',
  `isStick` int(11) unsigned NOT NULL DEFAULT '0',
  `lastPostMemberId` int(10) unsigned NOT NULL,
  `lastPostTime` int(10) unsigned NOT NULL,
  `groupId` int(10) unsigned NOT NULL,
  `userId` int(10) unsigned NOT NULL,
  `createdTime` int(10) unsigned NOT NULL COMMENT '添加时间',
  `postNum` int(10) unsigned NOT NULL DEFAULT '0',
  `status` enum('open','close') NOT NULL DEFAULT 'open',
  `hitNum` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `groups_thread_post`
-- ----------------------------
DROP TABLE IF EXISTS `groups_thread_post`;
CREATE TABLE `groups_thread_post` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id主键',
  `threadId` int(11) unsigned NOT NULL COMMENT '话题id',
  `content` text NOT NULL COMMENT '回复内容',
  `userId` int(10) unsigned NOT NULL COMMENT '回复人id',
  `postId` int(10) unsigned DEFAULT '0',
  `createdTime` int(10) unsigned NOT NULL COMMENT '回复时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `location`
-- ----------------------------
DROP TABLE IF EXISTS `location`;
CREATE TABLE `location` (
  `id` bigint(20) unsigned NOT NULL,
  `parentId` bigint(20) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `pinyin` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `log`
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '系统日志ID',
  `userId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作人ID',
  `module` varchar(32) NOT NULL COMMENT '日志所属模块',
  `action` varchar(32) NOT NULL COMMENT '日志所属操作类型',
  `message` text NOT NULL COMMENT '日志内容',
  `data` text COMMENT '日志数据',
  `ip` varchar(255) NOT NULL COMMENT '日志记录IP',
  `createdTime` int(10) unsigned NOT NULL COMMENT '日志发生时间',
  `level` char(10) NOT NULL COMMENT '日志等级',
  PRIMARY KEY (`id`),
  KEY `userId` (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=249 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `log`
-- ----------------------------
BEGIN;
INSERT INTO `log` VALUES ('1', '1', 'user', 'change_role', '设置用户熊先生(#1)的角色为：ROLE_USER,ROLE_TEACHER,ROLE_SUPER_ADMIN', '', '127.0.0.1', '1410920900', 'info'), ('2', '1', 'tag', 'create', '添加标签默认标签(#1)', '', '127.0.0.1', '1410920900', 'info'), ('3', '1', 'category', 'create', '添加分类 默认分类(#1)', '{\"id\":\"1\",\"code\":\"default\",\"name\":\"\\u9ed8\\u8ba4\\u5206\\u7c7b\",\"icon\":\"\",\"path\":\"\",\"weight\":\"100\",\"groupId\":\"1\",\"parentId\":\"0\",\"description\":null}', '127.0.0.1', '1410920900', 'info'), ('4', '1', 'content', 'create', '创建内容《(关于我们)》(1)', '{\"id\":\"1\",\"title\":\"\\u5173\\u4e8e\\u6211\\u4eec\",\"editor\":\"richeditor\",\"type\":\"page\",\"alias\":\"aboutus\",\"summary\":null,\"body\":\"\",\"picture\":\"\",\"template\":\"default\",\"status\":\"published\",\"categoryId\":\"0\",\"tagIds\":[],\"hits\":\"0\",\"featured\":\"0\",\"promoted\":\"1\",\"sticky\":\"0\",\"userId\":\"1\",\"field1\":null,\"field2\":null,\"field3\":null,\"field4\":null,\"field5\":null,\"field6\":null,\"field7\":null,\"field8\":null,\"field9\":null,\"field10\":null,\"publishedTime\":\"1410920900\",\"createdTime\":\"1410920900\"}', '127.0.0.1', '1410920900', 'info'), ('5', '1', 'content', 'create', '创建内容《(常见问题)》(2)', '{\"id\":\"2\",\"title\":\"\\u5e38\\u89c1\\u95ee\\u9898\",\"editor\":\"richeditor\",\"type\":\"page\",\"alias\":\"questions\",\"summary\":null,\"body\":\"\",\"picture\":\"\",\"template\":\"default\",\"status\":\"published\",\"categoryId\":\"0\",\"tagIds\":[],\"hits\":\"0\",\"featured\":\"0\",\"promoted\":\"1\",\"sticky\":\"0\",\"userId\":\"1\",\"field1\":null,\"field2\":null,\"field3\":null,\"field4\":null,\"field5\":null,\"field6\":null,\"field7\":null,\"field8\":null,\"field9\":null,\"field10\":null,\"publishedTime\":\"1410920900\",\"createdTime\":\"1410920900\"}', '127.0.0.1', '1410920900', 'info'), ('6', '1', 'info', 'navigation_create', '创建导航师资力量', '', '127.0.0.1', '1410920900', 'info'), ('7', '1', 'info', 'navigation_create', '创建导航常见问题', '', '127.0.0.1', '1410920900', 'info'), ('8', '1', 'info', 'navigation_create', '创建导航关于我们', '', '127.0.0.1', '1410920900', 'info'), ('9', '0', 'user', 'login_fail', '用户名：root，登录失败：帐号或密码不正确', '', '::1', '1410920920', 'info'), ('10', '1', 'user', 'login_success', '登录成功', '', '::1', '1410920934', 'info'), ('11', '1', 'user', 'login_success', '登录成功', '', '::1', '1410921062', 'info'), ('12', '1', 'user', 'approved', '用户熊先生实名认证成功，操作人:熊先生 !', '', '::1', '1410921095', 'info'), ('13', '1', 'course', 'create', '创建课程《装逼培训》(#1)', '', '::1', '1410921349', 'info'), ('14', '1', 'course', 'update', '更新课程《装逼培训》(#1)的信息', '{\"title\":\"\\u88c5\\u903c\\u57f9\\u8bad\",\"subtitle\":\"\\u88c5\\u903c\\u5165\\u95e8\",\"expiryDay\":30,\"showStudentNumType\":\"opened\",\"serializeMode\":\"serialize\",\"categoryId\":1,\"tags\":\"\"}', '::1', '1410921380', 'info'), ('15', '1', 'course', 'update', '更新课程《装逼培训》(#1)的信息', '{\"about\":\"\\u6ca1\\u89c1\\u89e3\\uff0c\\u5c31\\u662f\\u88c5\\u903c\",\"goals\":[\"\\u88c5\\u903c\\u5165\\u95e8\\u6210\\u529f\"],\"audiences\":[\"\\u5c4c\\u4e1d\"]}', '::1', '1410921415', 'info'), ('16', '1', 'course', 'update_picture', '更新课程《装逼培训》(#1)图片', '{\"smallPicture\":\"public:\\/\\/course\\/2014\\/09-17\\/103715b36a51834334.png\",\"middlePicture\":\"public:\\/\\/course\\/2014\\/09-17\\/103715b34d0d349483.png\",\"largePicture\":\"public:\\/\\/course\\/2014\\/09-17\\/103715b28f17458333.png\"}', '::1', '1410921435', 'info'), ('17', '1', 'course', 'add_lesson', '添加课时《装逼第一课》(1)', '{\"id\":\"1\",\"courseId\":\"1\",\"chapterId\":\"0\",\"number\":\"1\",\"seq\":\"1\",\"free\":\"1\",\"status\":\"published\",\"title\":\"\\u88c5\\u903c\\u7b2c\\u4e00\\u8bfe\",\"summary\":\"\\u88c5\\u903c\\u7b2c\\u4e00\\u8bfe\",\"tags\":null,\"type\":\"video\",\"content\":\"\",\"giveCredit\":\"0\",\"requireCredit\":\"0\",\"mediaId\":\"0\",\"mediaSource\":\"youku\",\"mediaName\":\"[\\u6b63\\u7247]\\u9648\\u4e39\\u9752 \\u6881\\u6587\\u9053\\u300a\\u97e9\\u6f6e\\u518d\\u88ad\\u300b\\u3010\\u8001\\u53cb\\u8bb0140917\\u3011\",\"mediaUri\":\"http:\\/\\/player.youku.com\\/player.php\\/sid\\/XNzgzMDkyNjY4_ev_1\\/v.swf\",\"length\":\"1800\",\"materialNum\":\"0\",\"quizNum\":\"0\",\"learnedNum\":\"0\",\"viewedNum\":\"0\",\"startTime\":\"0\",\"endTime\":\"0\",\"memberNum\":\"0\",\"replayStatus\":\"ungenerated\",\"userId\":\"1\",\"createdTime\":\"1410921501\"}', '::1', '1410921501', 'info'), ('18', '1', 'user', 'login_success', '登录成功', '', '::1', '1411038109', 'info'), ('19', '1', 'course', 'publish', '发布课程《装逼培训》(#1)', '', '::1', '1411038129', 'info'), ('20', '1', 'course', 'create', '熊先生观看课时《装逼第一课》', '', '::1', '1411038150', 'info'), ('21', '1', 'user', 'login_success', '登录成功', '', '::1', '1411038251', 'info'), ('22', '1', 'user', 'login_success', '登录成功', '', '::1', '1411050440', 'info'), ('23', '1', 'course', 'create', '熊先生观看课时《装逼第一课》', '', '::1', '1411050441', 'info'), ('24', '1', 'user', 'login_success', '登录成功', '', '::1', '1411052940', 'info'), ('25', '1', 'course', 'update_teacher', '更新课程#1的教师', '[{\"courseId\":\"1\",\"userId\":\"1\",\"role\":\"teacher\",\"seq\":0,\"isVisible\":1,\"createdTime\":1411053011}]', '::1', '1411053011', 'info'), ('26', '1', 'course', 'update', '更新课程《装逼培训》(#1)的信息', '{\"price\":5000}', '::1', '1411053038', 'info'), ('27', '1', 'category', 'create', '添加分类 人力资源(#2)', '{\"id\":\"2\",\"code\":\"S01\",\"name\":\"\\u4eba\\u529b\\u8d44\\u6e90\",\"icon\":\"\",\"path\":\"\",\"weight\":\"1\",\"groupId\":\"1\",\"parentId\":\"1\",\"description\":\"\\u4eba\\u529b\\u8d44\\u6e90\\u8bfe\\u7a0b\\u5305\"}', '::1', '1411054084', 'info'), ('28', '1', 'category', 'update', '编辑分类 人力资源(#2)', '{\"name\":\"\\u4eba\\u529b\\u8d44\\u6e90\",\"weight\":\"200\",\"code\":\"S01\",\"description\":\"\\u4eba\\u529b\\u8d44\\u6e90\\u8bfe\\u7a0b\\u5305\",\"icon\":\"\",\"parentId\":1,\"groupId\":1}', '::1', '1411054096', 'info'), ('29', '1', 'category', 'update', '编辑分类 人力资源(#2)', '{\"name\":\"\\u4eba\\u529b\\u8d44\\u6e90\",\"weight\":\"200\",\"code\":\"S01\",\"description\":\"\\u4eba\\u529b\\u8d44\\u6e90\\u8bfe\\u7a0b\\u5305\",\"icon\":\"\",\"parentId\":1,\"groupId\":1}', '::1', '1411054104', 'info'), ('30', '1', 'tag', 'update', '编辑标签不默认标签(#1)', '', '::1', '1411054124', 'info'), ('31', '1', 'info', 'navigation_create', '创建导航学习计划', '', '::1', '1411054242', 'info'), ('32', '1', 'info', 'navigation_create', '创建导航个人学习计划', '', '::1', '1411054278', 'info'), ('33', '1', 'info', 'navigation_create', '创建导航下属学习计划', '', '::1', '1411054300', 'info'), ('34', '1', 'info', 'navigation_update', '编辑导航#2', '{\"name\":\"\\u5e38\\u89c1\\u95ee\\u9898\",\"url\":\"page\\/questions\",\"sequence\":\"3\",\"type\":\"top\",\"isNewWin\":\"0\",\"isOpen\":\"1\",\"parentId\":\"0\",\"updateTime\":1411054326}', '::1', '1411054326', 'info'), ('35', '1', 'info', 'navigation_update', '编辑导航#3', '{\"name\":\"\\u5173\\u4e8e\\u6211\\u4eec\",\"url\":\"page\\/aboutus\",\"sequence\":\"4\",\"type\":\"top\",\"isNewWin\":\"0\",\"isOpen\":\"1\",\"parentId\":\"0\",\"updateTime\":1411054331}', '::1', '1411054331', 'info'), ('36', '1', 'info', 'navigation_create', '创建导航底部导航', '', '::1', '1411054367', 'info'), ('37', '1', 'info', 'navigation_create', '创建导航记得联系我', '', '::1', '1411054402', 'info'), ('38', '1', 'content', 'update', '内容《(关于我们)》(1)更新', '{\"id\":\"1\",\"title\":\"\\u5173\\u4e8e\\u6211\\u4eec\",\"editor\":\"richeditor\",\"type\":\"page\",\"alias\":\"aboutus\",\"summary\":null,\"body\":\"\",\"picture\":\"\",\"template\":\"default\",\"status\":\"published\",\"categoryId\":\"0\",\"tagIds\":[],\"hits\":\"0\",\"featured\":\"0\",\"promoted\":\"0\",\"sticky\":\"0\",\"userId\":\"1\",\"field1\":null,\"field2\":null,\"field3\":null,\"field4\":null,\"field5\":null,\"field6\":null,\"field7\":null,\"field8\":null,\"field9\":null,\"field10\":null,\"publishedTime\":\"1410920900\",\"createdTime\":\"1410920900\"}', '::1', '1411054497', 'info'), ('39', '1', 'info', 'navigation_update', '编辑导航#1', '{\"name\":\"\\u5e08\\u8d44\\u529b\\u91cf\",\"url\":\"teacher\",\"sequence\":\"1\",\"type\":\"top\",\"isNewWin\":\"0\",\"isOpen\":\"1\",\"parentId\":\"0\",\"updateTime\":1411054516}', '::1', '1411054516', 'info'), ('40', '1', 'user', 'recommend', '推荐用户熊先生(#1)', '', '::1', '1411054575', 'info'), ('41', '1', 'user', 'cancel_recommend', '取消推荐用户熊先生(#1)', '', '::1', '1411054580', 'info'), ('42', '1', 'content', 'create', '创建内容《(培训管理)》(3)', '{\"id\":\"3\",\"title\":\"\\u57f9\\u8bad\\u7ba1\\u7406\",\"editor\":\"richeditor\",\"type\":\"page\",\"alias\":\"management\",\"summary\":null,\"body\":\"\",\"picture\":\"\",\"template\":\"default\",\"status\":\"published\",\"categoryId\":\"0\",\"tagIds\":[],\"hits\":\"0\",\"featured\":\"0\",\"promoted\":\"0\",\"sticky\":\"0\",\"userId\":\"1\",\"field1\":null,\"field2\":null,\"field3\":null,\"field4\":null,\"field5\":null,\"field6\":null,\"field7\":null,\"field8\":null,\"field9\":null,\"field10\":null,\"publishedTime\":\"1411054612\",\"createdTime\":\"1411054638\"}', '::1', '1411054638', 'info'), ('43', '1', 'block', 'update', '更新编辑区#1', '{\"content\":\"<a href=\\\"\\\"><img src=\\\"..\\/assets\\/img\\/placeholder\\/carousel-1200x256-1.png\\\" \\/><\\/a>\\r\\n<a href=\\\"#\\\"><img src=\\\"..\\/assets\\/img\\/placeholder\\/carousel-1200x256-2.png\\\" \\/><\\/a>\\r\\n<a href=\\\"#\\\"><img src=\\\"..\\/assets\\/img\\/placeholder\\/carousel-1200x256-3.png\\\" \\/><\\/a>\\r\\n<img src=\\\"\\/edusoho\\/web\\/files\\/default\\/2014\\/09-18\\/2338306e8ce5518461.jpg?3.7.5\\\">\"}', '::1', '1411054736', 'info'), ('44', '1', 'category', 'create', '添加栏目 科技快讯(#1)', '{\"id\":\"1\",\"name\":\"\\u79d1\\u6280\\u5feb\\u8baf\",\"code\":\"news\",\"weight\":\"0\",\"publishArticle\":\"1\",\"seoTitle\":\"\\u79d1\\u6280\",\"seoKeyword\":\"\\u79d1\\u6280\",\"seoDesc\":\"\\u79d1\\u6280\",\"published\":\"1\",\"parentId\":\"0\",\"createdTime\":\"1411054906\"}', '::1', '1411054906', 'info'), ('45', '1', 'category', 'create', '添加栏目 科技top10(#2)', '{\"id\":\"2\",\"name\":\"\\u79d1\\u6280top10\",\"code\":\"top10\",\"weight\":\"0\",\"publishArticle\":\"1\",\"seoTitle\":\"top10\",\"seoKeyword\":\"top10\",\"seoDesc\":\"top10\",\"published\":\"1\",\"parentId\":\"1\",\"createdTime\":\"1411054933\"}', '::1', '1411054933', 'info'), ('46', '1', 'article', 'update_settings', '更新资讯频道设置', '{\"name\":\"\\u8d44\\u8baf\\u9891\\u9053\",\"pageNums\":\"5\"}', '::1', '1411054945', 'info'), ('47', '1', 'ajax', 'exception', 'Length of either side cannot be 0 or negative, current size is x', '', '::1', '1411055071', 'error'), ('48', '1', 'ajax', 'exception', 'Length of either side cannot be 0 or negative, current size is x', '', '::1', '1411055073', 'error'), ('49', '1', 'user', 'login_success', '登录成功', '', '::1', '1411055108', 'info'), ('50', '1', 'article', 'create', '创建文章《(iPhone6终于发布了)》(1)', '', '::1', '1411055218', 'info'), ('51', '1', 'Article', 'update', '修改文章《(iPhone6终于发布了)》(1)', '', '::1', '1411055389', 'info'), ('52', '1', 'article', 'create', '创建文章《(Moto 360 背后的设计故事)》(2)', '', '::1', '1411055528', 'info'), ('53', '1', 'info', 'navigation_create', '创建导航科技资讯', '', '::1', '1411055607', 'info'), ('54', '1', 'info', 'navigation_update', '编辑导航#9', '{\"name\":\"\\u79d1\\u6280\\u8d44\\u8baf\",\"url\":\"article\",\"sequence\":\"5\",\"type\":\"top\",\"isNewWin\":\"0\",\"isOpen\":\"1\",\"parentId\":\"0\",\"updateTime\":1411055630}', '::1', '1411055630', 'info'), ('55', '1', 'category', 'delete', '删除栏目科技top10(#2)', '', '::1', '1411055690', 'info'), ('56', '1', 'category', 'create', '添加栏目 今日头条(#3)', '{\"id\":\"3\",\"name\":\"\\u4eca\\u65e5\\u5934\\u6761\",\"code\":\"bbs\",\"weight\":\"1\",\"publishArticle\":\"1\",\"seoTitle\":\"\",\"seoKeyword\":\"\",\"seoDesc\":\"\",\"published\":\"1\",\"parentId\":\"0\",\"createdTime\":\"1411055743\"}', '::1', '1411055743', 'info'), ('57', '1', 'Article', 'update', '修改文章《(Moto 360 背后的设计故事)》(2)', '', '::1', '1411055776', 'info'), ('58', '1', 'Article', 'update', '修改文章《(iPhone6终于发布了)》(1)', '', '::1', '1411055807', 'info'), ('59', '1', 'Article', 'update', '修改文章《(iPhone6终于发布了)》(1)', '', '::1', '1411055829', 'info'), ('60', '1', 'setArticleProperty', 'updateArticleProperty', '文章#1,0=>1', '', '::1', '1411055838', 'info'), ('61', '1', 'setArticleProperty', 'updateArticleProperty', '文章#2,0=>1', '', '::1', '1411055842', 'info'), ('62', '1', 'setArticleProperty', 'updateArticleProperty', '文章#2,0=>1', '', '::1', '1411055842', 'info'), ('63', '1', 'cancelArticleProperty', 'updateArticleProperty', '文章#2,1=>0', '', '::1', '1411055864', 'info'), ('64', '1', 'Article', 'update', '修改文章《(iPhone6终于发布了)》(1)', '', '::1', '1411055887', 'info'), ('65', '1', 'setArticleProperty', 'updateArticleProperty', '文章#2,0=>1', '', '::1', '1411055894', 'info'), ('66', '1', 'setArticleProperty', 'updateArticleProperty', '文章#1,0=>1', '', '::1', '1411055904', 'info'), ('67', '1', 'setArticleProperty', 'updateArticleProperty', '文章#1,0=>1', '', '::1', '1411055921', 'info'), ('68', '1', 'setArticleProperty', 'updateArticleProperty', '文章#1,0=>1', '', '::1', '1411055922', 'info'), ('69', '1', 'content', 'create', '创建内容《(学习小组)》(4)', '{\"id\":\"4\",\"title\":\"\\u5b66\\u4e60\\u5c0f\\u7ec4\",\"editor\":\"richeditor\",\"type\":\"page\",\"alias\":\"group\",\"summary\":null,\"body\":\"\",\"picture\":\"\",\"template\":\"default\",\"status\":\"published\",\"categoryId\":\"0\",\"tagIds\":[],\"hits\":\"0\",\"featured\":\"0\",\"promoted\":\"0\",\"sticky\":\"0\",\"userId\":\"1\",\"field1\":null,\"field2\":null,\"field3\":null,\"field4\":null,\"field5\":null,\"field6\":null,\"field7\":null,\"field8\":null,\"field9\":null,\"field10\":null,\"publishedTime\":\"1411056236\",\"createdTime\":\"1411056247\"}', '::1', '1411056247', 'info'), ('70', '1', 'info', 'navigation_create', '创建导航学习小组', '', '::1', '1411056293', 'info'), ('71', '1', 'info', 'navigation_update', '编辑导航#5', '{\"name\":\"\\u4e2a\\u4eba\\u5b66\\u4e60\\u8ba1\\u5212\",\"url\":\"\",\"sequence\":\"2\",\"type\":\"top\",\"isNewWin\":\"0\",\"isOpen\":\"1\",\"parentId\":\"4\",\"updateTime\":1411056301}', '::1', '1411056301', 'info'), ('72', '1', 'info', 'navigation_update', '编辑导航#6', '{\"name\":\"\\u4e0b\\u5c5e\\u5b66\\u4e60\\u8ba1\\u5212\",\"url\":\"\",\"sequence\":\"3\",\"type\":\"top\",\"isNewWin\":\"0\",\"isOpen\":\"1\",\"parentId\":\"4\",\"updateTime\":1411056307}', '::1', '1411056307', 'info'), ('73', '1', 'system', 'update_settings', '更新站点设置', '{\"name\":\"Mr`Bear\",\"slogan\":\"\",\"url\":\"\",\"logo\":\"\",\"favicon\":\"\",\"seo_keywords\":\"\",\"seo_description\":\"\",\"master_email\":\"tongzhenke@gmail.com\",\"copyright\":\"\",\"icp\":\"\",\"analytics\":\"\",\"status\":\"open\",\"closed_note\":\"\"}', '::1', '1411056664', 'info'), ('74', '1', 'system', 'update_settings', '更新站点LOGO', '{\"logo\":\"files\\/system\\/logo_1411056709.jpg\"}', '::1', '1411056709', 'info'), ('75', '1', 'system', 'update_settings', '移除站点LOGO', '', '::1', '1411056717', 'info'), ('76', '1', 'system', 'update_settings', '更新站点设置', '{\"name\":\"Mr\\u2019Bear\\u5728\\u7ebf\\u57f9\\u8bad\\u5e73\\u53f0\",\"slogan\":\"\",\"url\":\"\",\"logo\":\"\",\"favicon\":\"\",\"seo_keywords\":\"\\u718a\\u5148\\u751f\",\"seo_description\":\"\\u718a\\u5148\\u751f\\u5728\\u7ebf\\u57f9\\u8bad\\u5e73\\u53f0\",\"master_email\":\"tongzhenke@gmail.com\",\"copyright\":\"\\u718a\\u5148\\u751f\",\"icp\":\"\",\"analytics\":\"\",\"status\":\"open\",\"closed_note\":\"\"}', '::1', '1411056928', 'info'), ('77', '2', 'user', 'login_success', '登录成功', '', '::1', '1411057527', 'info'), ('78', '1', 'user', 'login_success', '登录成功', '', '::1', '1411057671', 'info'), ('79', '1', 'block', 'update', '更新编辑区#1', '{\"content\":\"<a href=\\\"http:\\/\\/cn.engadget.com\\/2014\\/09\\/18\\/play-store-material-design-leak\\/\\\"><img src=\\\"\\/edusoho\\/web\\/files\\/default\\/2014\\/09-19\\/002919fc24a1378347.jpg?3.7.5\\\"><\\/a>\\r\\n<a href=\\\"http:\\/\\/cn.engadget.com\\/2014\\/09\\/18\\/play-store-material-design-leak\\/\\\"><img src=\\\"\\/edusoho\\/web\\/files\\/default\\/2014\\/09-19\\/0029255311e3278226.jpg?3.7.5\\\"><\\/a>\\r\\n<a href=\\\"http:\\/\\/cn.engadget.com\\/2014\\/09\\/18\\/play-store-material-design-leak\\/\\\"><img src=\\\"\\/edusoho\\/web\\/files\\/default\\/2014\\/09-19\\/002931b87340271391.jpg?3.7.5\\\"><\\/a>\\r\\n<a href=\\\"http:\\/\\/cn.engadget.com\\/2014\\/09\\/18\\/play-store-material-design-leak\\/\\\"><img src=\\\"\\/edusoho\\/web\\/files\\/default\\/2014\\/09-19\\/0029360a0426696040.jpg?3.7.5\\\"><\\/a>\"}', '::1', '1411057834', 'info'), ('80', '2', 'user', 'login_success', '登录成功', '', '::1', '1411057849', 'info'), ('81', '1', 'user', 'login_success', '登录成功', '', '::1', '1411057964', 'info'), ('82', '2', 'user', 'login_success', '登录成功', '', '::1', '1411089864', 'info'), ('83', '1', 'user', 'login_success', '登录成功', '', '::1', '1411092177', 'info'), ('84', '1', 'course', 'update', '更新课程《装逼培训》(#1)的信息', '{\"about\":\"\\u6ca1\\u89c1\\u89e3\\uff0c\\u5c31\\u662f\\u88c5\\u903c\",\"goals\":[\"\\u88c5\\u903c\\u5165\\u95e8\\u6210\\u529f\",\"\\u88c5\\u903c\\u5927\\u795e\"],\"audiences\":[\"\\u5c4c\\u4e1d\",\"\\u571f\\u8c6a\"]}', '::1', '1411092246', 'info'), ('85', '2', 'user', 'login_success', '登录成功', '', '::1', '1411093243', 'info'), ('86', '2', 'user', 'login_success', '登录成功', '', '::1', '1411093404', 'info'), ('87', '1', 'user', 'approved', '用户阿蓝实名认证成功，操作人:熊先生 !', '', '::1', '1411093492', 'info'), ('88', '1', 'user', 'change_role', '设置用户阿蓝(#2)的角色为：ROLE_USER,ROLE_TEACHER', '', '::1', '1411093785', 'info'), ('89', '1', 'user', 'change_role', '设置用户阿柯(#3)的角色为：ROLE_TEACHER,ROLE_USER', '', '::1', '1411093825', 'info'), ('90', '1', 'user', 'add', '管理员添加新用户 阿柯 (3)', '', '::1', '1411093825', 'info'), ('91', '3', 'user', 'login_success', '登录成功', '', '::1', '1411093852', 'info'), ('92', '1', 'user', 'login_success', '登录成功', '', '::1', '1411093904', 'info'), ('93', '1', 'user', 'change_role', '设置用户阿柯(#3)的角色为：ROLE_USER,ROLE_ADMIN', '', '::1', '1411093934', 'info'), ('94', '1', 'course', 'cancel_teachers_all', '取消用户#3所有的课程老师角色', '', '::1', '1411093934', 'info'), ('95', '3', 'user', 'login_success', '登录成功', '', '::1', '1411093947', 'info'), ('96', '1', 'user', 'login_success', '登录成功', '', '::1', '1411093998', 'info'), ('97', '3', 'user', 'login_success', '登录成功', '', '::1', '1411094025', 'info'), ('98', '3', 'user', 'lock', '封禁用户熊先生(#1)', '', '::1', '1411094040', 'info'), ('99', '3', 'user', 'unlock', '解禁用户熊先生(#1)', '', '::1', '1411094046', 'info'), ('100', '1', 'user', 'login_success', '登录成功', '', '::1', '1411094075', 'info'), ('101', '1', 'course', 'create', '创建课程《如果成为屌丝》(#2)', '', '::1', '1411094303', 'info'), ('102', '1', 'course', 'update', '更新课程《如果成为屌丝》(#2)的信息', '{\"title\":\"\\u5982\\u679c\\u6210\\u4e3a\\u5c4c\\u4e1d\",\"subtitle\":\"\\u73b0\\u5728\\u6559\\u4f60\\u600e\\u4e48\\u6837\\u6210\\u4e3a\\u4e00\\u4f4d\\u6210\\u529f\\u7684\\u5c4c\\u4e1d\",\"expiryDay\":90,\"showStudentNumType\":\"opened\",\"serializeMode\":\"serialize\",\"categoryId\":0,\"tags\":\"\"}', '::1', '1411094341', 'info'), ('103', '1', 'course', 'update', '更新课程《如果成为屌丝》(#2)的信息', '{\"title\":\"\\u5982\\u4f55\\u6210\\u4e3a\\u5c4c\\u4e1d\",\"subtitle\":\"\\u73b0\\u5728\\u6559\\u4f60\\u600e\\u4e48\\u6837\\u6210\\u4e3a\\u4e00\\u4f4d\\u6210\\u529f\\u7684\\u5c4c\\u4e1d\",\"expiryDay\":90,\"showStudentNumType\":\"opened\",\"serializeMode\":\"serialize\",\"categoryId\":0,\"tags\":\"\"}', '::1', '1411094365', 'info'), ('104', '1', 'course', 'update', '更新课程《如何成为屌丝》(#2)的信息', '{\"about\":\"\\u6211\\u6765\\u6559\\u4f60\\u600e\\u4e48\\u6837\\u6210\\u4e3a\\u4e00\\u540d\\u6210\\u529f\\u7684\\u5c4c\\u4e1d\",\"goals\":[\"\\u8fdb\\u9636\\u6210\\u4e00\\u540d\\u6210\\u529f\\u7684\\u5c4c\\u4e1d\"],\"audiences\":[\"\\u4e8c\\u903c\",\"\\u4e8c\\u8d27\"]}', '::1', '1411094418', 'info'), ('105', '1', 'course', 'update_picture', '更新课程《如何成为屌丝》(#2)图片', '{\"smallPicture\":\"public:\\/\\/course\\/2014\\/09-19\\/104046eb8396075033.jpg\",\"middlePicture\":\"public:\\/\\/course\\/2014\\/09-19\\/104046eb69ca271406.jpg\",\"largePicture\":\"public:\\/\\/course\\/2014\\/09-19\\/104046eafb29879452.jpg\"}', '::1', '1411094446', 'info'), ('106', '2', 'user', 'login_success', '登录成功', '', '::1', '1411095549', 'info'), ('107', '1', 'course', 'update_teacher', '更新课程#2的教师', '[{\"courseId\":\"2\",\"userId\":\"2\",\"role\":\"teacher\",\"seq\":0,\"isVisible\":1,\"createdTime\":1411095601}]', '::1', '1411095601', 'info'), ('108', '1', 'course', 'publish', '发布课程《如何成为屌丝》(#2)', '', '::1', '1411095666', 'info'), ('109', '1', 'course', 'add_student', '课程《如何成为屌丝》(#2)，添加学员熊先生(#1)，备注：', '', '::1', '1411095682', 'info'), ('110', '1', 'course', 'add_student', '课程《如何成为屌丝》(#2)，添加学员阿柯(#3)，备注：', '', '::1', '1411095692', 'info'), ('111', '1', 'course', 'recommend', '推荐课程《如何成为屌丝》(#2),序号为0', '', '::1', '1411095998', 'info'), ('112', '2', 'course', 'create', '创建课程《设计模式》(#3)', '', '::1', '1411097209', 'info'), ('113', '2', 'course', 'update', '更新课程《设计模式》(#3)的信息', '{\"title\":\"\\u8bbe\\u8ba1\\u6a21\\u5f0f\",\"subtitle\":\"\\u8bbe\\u8ba1\\u6a21\\u5f0f\",\"expiryDay\":90,\"showStudentNumType\":\"opened\",\"serializeMode\":\"serialize\",\"categoryId\":0,\"tags\":\"\"}', '::1', '1411097222', 'info'), ('114', '2', 'course', 'update', '更新课程《设计模式》(#3)的信息', '{\"about\":\"\\u8bbe\\u8ba1\\u6a21\\u5f0f\",\"goals\":[\"\\u638c\\u63e1\\u8bbe\\u8ba1\\u6a21\\u5f0f\\u7cbe\\u9ad3\"],\"audiences\":[\"\\u8bbe\\u8ba1\\u4eba\\u5458\",\"\\u5f00\\u53d1\\u4eba\\u5458\"]}', '::1', '1411097270', 'info'), ('115', '2', 'course', 'add_lesson', '添加课时《策略模式》(2)', '{\"id\":\"2\",\"courseId\":\"3\",\"chapterId\":\"0\",\"number\":\"1\",\"seq\":\"1\",\"free\":\"1\",\"status\":\"published\",\"title\":\"\\u7b56\\u7565\\u6a21\\u5f0f\",\"summary\":\"\\u5b9a\\u4e49\\u4e86\\u7b97\\u6cd5\\u65cf\\uff0c\\u5206\\u522b\\u5c01\\u88c5\\u8d77\\u6765\\uff0c\\u8ba9\\u4ed6\\u4eec\\u4e4b\\u95f4\\u53ef\\u4ee5\\u4e92\\u76f8\\u66ff\\u6362\\uff0c\\u6b64\\u6a21\\u5f0f\\u8ba9\\u7b97\\u6cd5\\u7684\\u53d8\\u5316\\u72ec\\u7acb\\u4e8e\\u4f7f\\u7528\\u7b97\\u6cd5\\u7684\\u5ba2\\u6237\",\"tags\":null,\"type\":\"text\",\"content\":\"<!--?xml version=\\\"1.0\\\" encoding=\\\"UTF-8\\\" standalone=\\\"no\\\"?--> <span style=\\\"color:#000000;font-family:\'Microsoft YaHei\';font-size:medium;line-height:normal;\\\">\\u7b56\\u7565\\u6a21\\u5f0f<\\/span>\\r\\n<div style=\\\"color:#000000;font-family:\'Microsoft YaHei\';font-size:medium;\\\">\\r\\n\\t\\uff1a\\u5b9a\\u4e49\\u4e86\\u7b97\\u6cd5\\u65cf\\uff0c\\u5206\\u522b\\u5c01\\u88c5\\u8d77\\u6765\\uff0c\\u8ba9\\u4ed6\\u4eec\\u4e4b\\u95f4\\u53ef\\u4ee5\\u4e92\\u76f8\\u66ff\\u6362\\uff0c\\u6b64\\u6a21\\u5f0f\\u8ba9\\u7b97\\u6cd5\\u7684\\u53d8\\u5316\\u72ec\\u7acb\\u4e8e\\u4f7f\\u7528\\u7b97\\u6cd5\\u7684\\u5ba2\\u6237\\u3002&nbsp;\\r\\n<\\/div>\\r\\n<!--?xml version=\\\"1.0\\\" encoding=\\\"UTF-8\\\" standalone=\\\"no\\\"?--><span style=\\\"color:#000000;font-family:\'Microsoft YaHei\';font-size:medium;line-height:normal;\\\"><\\/span>\",\"giveCredit\":\"0\",\"requireCredit\":\"0\",\"mediaId\":\"0\",\"mediaSource\":\"\",\"mediaName\":\"\",\"mediaUri\":\"\",\"length\":null,\"materialNum\":\"0\",\"quizNum\":\"0\",\"learnedNum\":\"0\",\"viewedNum\":\"0\",\"startTime\":\"0\",\"endTime\":\"0\",\"memberNum\":\"0\",\"replayStatus\":\"ungenerated\",\"userId\":\"2\",\"createdTime\":\"1411097342\"}', '::1', '1411097342', 'info'), ('116', '2', 'course', 'add_lesson', '添加课时《观察者模式》(3)', '{\"id\":\"3\",\"courseId\":\"3\",\"chapterId\":\"0\",\"number\":\"2\",\"seq\":\"2\",\"free\":\"1\",\"status\":\"published\",\"title\":\"\\u89c2\\u5bdf\\u8005\\u6a21\\u5f0f\",\"summary\":\"\\u89c2\\u5bdf\\u8005\\u6a21\\u5f0f\",\"tags\":null,\"type\":\"text\",\"content\":\"<!--?xml version=\\\"1.0\\\" encoding=\\\"UTF-8\\\" standalone=\\\"no\\\"?-->\\r\\n<div style=\\\"color:#000000;font-family:\'Microsoft YaHei\';font-size:medium;\\\">\\r\\n\\t\\u89c2\\u5bdf\\u8005\\u6a21\\u5f0f\\r\\n<\\/div>\\r\\n<div style=\\\"color:#000000;font-family:\'Microsoft YaHei\';font-size:medium;\\\">\\r\\n\\t\\uff1a\\u5b9a\\u4e49\\u4e86\\u5bf9\\u8c61\\u4e4b\\u95f4\\u7684\\u4e00\\u5bf9\\u591a\\u4f9d\\u8d56\\uff0c\\u5f53\\u4e00\\u4e2a\\u5bf9\\u8c61\\u53d1\\u751f\\u6539\\u53d8\\u65f6\\uff0c\\u5b83\\u7684\\u4f9d\\u8d56\\u8005\\u4eec\\u5c31\\u4f1a\\u53d7\\u5230\\u901a\\u77e5\\u5e76\\u81ea\\u52a8\\u66f4\\u65b0\\u3002&nbsp;\\r\\n<\\/div>\",\"giveCredit\":\"0\",\"requireCredit\":\"0\",\"mediaId\":\"0\",\"mediaSource\":\"\",\"mediaName\":\"\",\"mediaUri\":\"\",\"length\":null,\"materialNum\":\"0\",\"quizNum\":\"0\",\"learnedNum\":\"0\",\"viewedNum\":\"0\",\"startTime\":\"0\",\"endTime\":\"0\",\"memberNum\":\"0\",\"replayStatus\":\"ungenerated\",\"userId\":\"2\",\"createdTime\":\"1411097363\"}', '::1', '1411097363', 'info'), ('117', '2', 'course', 'publish', '发布课程《设计模式》(#3)', '', '::1', '1411097369', 'info'), ('118', '2', 'user', 'login_success', '登录成功', '', '::1', '1411097416', 'info'), ('119', '3', 'user', 'login_success', '登录成功', '', '::1', '1411097430', 'info'), ('120', '2', 'user', 'login_success', '登录成功', '', '::1', '1411105772', 'info'), ('121', '3', 'user', 'login_success', '登录成功', '', '::1', '1411105791', 'info'), ('122', '3', 'user', 'add', '管理员添加新用户 凌峰 (4)', '', '::1', '1411105908', 'info'), ('123', '4', 'user', 'login_success', '登录成功', '', '::1', '1411105921', 'info'), ('124', '4', 'user', 'login_success', '登录成功', '', '::1', '1411107788', 'info'), ('125', '1', 'user', 'login_success', '登录成功', '', '::1', '1411107796', 'info'), ('126', '3', 'user', 'login_success', '登录成功', '', '::1', '1411107953', 'info'), ('127', '3', 'user', 'login_success', '登录成功', '', '::1', '1411112654', 'info'), ('128', '1', 'user', 'login_success', '登录成功', '', '::1', '1411115239', 'info'), ('129', '1', 'course', 'create', '创建课程《Demo课程》(#4)', '', '::1', '1411115336', 'info'), ('130', '1', 'user', 'login_success', '登录成功', '', '::1', '1411116514', 'info'), ('131', '1', 'user', 'login_success', '登录成功', '', '::1', '1411121614', 'info'), ('132', '1', 'user', 'login_success', '登录成功', '', '::1', '1411198258', 'info'), ('133', '1', 'user', 'login_success', '登录成功', '', '::1', '1411198258', 'info'), ('134', '1', 'user', 'login_success', '登录成功', '', '::1', '1411199164', 'info'), ('135', '1', 'user', 'login_success', '登录成功', '', '::1', '1411205002', 'info'), ('136', '1', 'user', 'login_success', '登录成功', '', '::1', '1411207139', 'info'), ('137', '1', 'course', 'add_lesson', '添加课时《装逼第二课》(4)', '{\"id\":\"4\",\"courseId\":\"1\",\"chapterId\":\"0\",\"number\":\"2\",\"seq\":\"2\",\"free\":\"0\",\"status\":\"unpublished\",\"title\":\"\\u88c5\\u903c\\u7b2c\\u4e8c\\u8bfe\",\"summary\":\"\\u88c5\\u903c\\u8fdb\\u9636\\u8bfe\\u7a0b\",\"tags\":null,\"type\":\"text\",\"content\":\"\\u6162\\u6162\\u7684\\u4f1a\\u88c5\\u903c\\u4e86\",\"giveCredit\":\"0\",\"requireCredit\":\"0\",\"mediaId\":\"0\",\"mediaSource\":\"\",\"mediaName\":\"\",\"mediaUri\":\"\",\"length\":null,\"materialNum\":\"0\",\"quizNum\":\"0\",\"learnedNum\":\"0\",\"viewedNum\":\"0\",\"startTime\":\"0\",\"endTime\":\"0\",\"memberNum\":\"0\",\"replayStatus\":\"ungenerated\",\"userId\":\"1\",\"createdTime\":\"1411207182\"}', '::1', '1411207182', 'info'), ('138', '1', 'course', 'create', '熊先生观看课时《装逼第二课》', '', '::1', '1411208418', 'info'), ('139', '2', 'user', 'login_success', '登录成功', '', '::1', '1411208473', 'info'), ('140', '1', 'user', 'login_success', '登录成功', '', '::1', '1411208486', 'info'), ('141', '1', 'course', 'update', '更新课程《装逼培训》(#1)的信息', '{\"price\":0}', '::1', '1411208522', 'info'), ('142', '2', 'user', 'login_success', '登录成功', '', '::1', '1411208534', 'info'), ('143', '2', 'course', 'create', '阿蓝观看课时《装逼第一课》', '', '::1', '1411208576', 'info'), ('144', '2', 'course', 'create', '阿蓝观看课时《装逼第二课》', '', '::1', '1411208586', 'info'), ('145', '1', 'user', 'login_success', '登录成功', '', '::1', '1411208626', 'info'), ('146', '1', 'user', 'login_success', '登录成功', '', '::1', '1411208709', 'info'), ('147', '2', 'user', 'login_success', '登录成功', '', '::1', '1411208721', 'info'), ('148', '1', 'course', 'add_lesson', '添加课时《装逼考试》(5)', '{\"id\":\"5\",\"courseId\":\"1\",\"chapterId\":\"0\",\"number\":\"3\",\"seq\":\"3\",\"free\":\"0\",\"status\":\"unpublished\",\"title\":\"\\u88c5\\u903c\\u8003\\u8bd5\",\"summary\":null,\"tags\":null,\"type\":\"testpaper\",\"content\":null,\"giveCredit\":\"0\",\"requireCredit\":\"0\",\"mediaId\":\"1\",\"mediaSource\":\"\",\"mediaName\":\"\",\"mediaUri\":null,\"length\":null,\"materialNum\":\"0\",\"quizNum\":\"0\",\"learnedNum\":\"0\",\"viewedNum\":\"0\",\"startTime\":\"0\",\"endTime\":\"0\",\"memberNum\":\"0\",\"replayStatus\":\"ungenerated\",\"userId\":\"1\",\"createdTime\":\"1411209159\"}', '::1', '1411209159', 'info'), ('149', '2', 'course', 'create', '阿蓝观看课时《装逼考试》', '', '::1', '1411209192', 'info'), ('150', '2', 'course', 'create', '阿蓝观看课时《装逼考试》', '', '::1', '1411209428', 'info'), ('151', '2', 'user', 'login_success', '登录成功', '', '::1', '1411209444', 'info'), ('152', '2', 'user', 'login_success', '登录成功', '', '::1', '1411211366', 'info'), ('153', '1', 'user', 'login_success', '登录成功', '', '::1', '1411288211', 'info'), ('154', '2', 'user', 'login_success', '登录成功', '', '::1', '1411289259', 'info'), ('155', '2', 'course', 'create', '阿蓝观看课时《装逼第一课》', '', '::1', '1411289275', 'info'), ('156', '2', 'user', 'login_success', '登录成功', '', '::1', '1411292026', 'info'), ('157', '1', 'user', 'login_success', '登录成功', '', '::1', '1411292455', 'info'), ('158', '1', 'user', 'login_success', '登录成功', '', '::1', '1411294312', 'info'), ('159', '1', 'user', 'login_success', '登录成功', '', '::1', '1411296688', 'info'), ('160', '1', 'user', 'login_success', '登录成功', '', '::1', '1411298690', 'info'), ('161', '2', 'user', 'login_success', '登录成功', '', '::1', '1411301855', 'info'), ('162', '2', 'user', 'login_success', '登录成功', '', '::1', '1411301858', 'info'), ('163', '2', 'user', 'login_success', '登录成功', '', '::1', '1411301877', 'info'), ('164', '1', 'user', 'login_success', '登录成功', '', '::1', '1411396485', 'info'), ('165', '1', 'user', 'login_success', '登录成功', '', '::1', '1415243515', 'info'), ('166', '1', 'user', 'login_success', '登录成功', '', '127.0.0.1', '1419056481', 'info'), ('167', '1', 'course', 'create', '熊先生观看课时《装逼考试》', '', '::1', '1419056637', 'info'), ('168', '1', 'system', 'update_settings', '更新站点设置', '{\"name\":\"Vigor\\u5728\\u7ebf\\u57f9\\u8bad\\u5e73\\u53f0\",\"slogan\":\"\\u6c7d\\u8f66\\u54a8\\u8be2\\u4e13\\u5bb6\",\"url\":\"\",\"logo\":\"\",\"favicon\":\"\",\"seo_keywords\":\"\\u529b\\u6d3b\",\"seo_description\":\"\\u4e0a\\u6d77\\u529b\\u6d3b\\u4fe1\\u606f\\u6280\\u672f\\u6709\\u9650\\u516c\\u53f8\",\"master_email\":\"java_rainy@126.com\",\"copyright\":\"\\u718a\\u5148\\u751f\",\"icp\":\"\",\"analytics\":\"\",\"status\":\"open\",\"closed_note\":\"\"}', '::1', '1419057032', 'info'), ('169', '1', 'user', 'login_success', '登录成功', '', '::1', '1419065507', 'info'), ('170', '1', 'user', 'login_success', '登录成功', '', '::1', '1419071106', 'info'), ('171', '1', 'system', 'update_settings', '更新课程设置', '{\"welcome_message_enabled\":\"1\",\"welcome_message_body\":\"{{nickname}},\\u6b22\\u8fce\\u52a0\\u5165\\u8bfe\\u7a0b{{course}}\",\"buy_fill_userinfo\":\"0\",\"userinfoFieldNameArray\":[\"truename\",\"mobile\",\"qq\",\"company\",\"job\",\"gender\",\"idcard\",\"weibo\",\"weixin\"],\"teacher_modify_price\":\"1\",\"teacher_manage_student\":\"0\",\"teacher_export_student\":\"0\",\"student_download_media\":\"0\",\"relatedCourses\":\"0\",\"allowAnonymousPreview\":\"1\",\"live_course_enabled\":\"0\",\"live_student_capacity\":0,\"userinfoFields\":[]}', '::1', '1419071106', 'info'), ('172', '1', 'user', 'login_success', '登录成功', '', '::1', '1419074591', 'info'), ('173', '1', 'user', 'recommend', '推荐用户熊先生(#1)', '', '::1', '1419074945', 'info'), ('174', '1', 'course', 'cancel_recommend', '取消推荐课程《如何成为屌丝》(#2)', '', '::1', '1419075035', 'info'), ('175', '1', 'user', 'login_success', '登录成功', '', '::1', '1419083258', 'info'), ('176', '1', 'user', 'login_success', '登录成功', '', '::1', '1419140060', 'info'), ('177', '1', 'course', 'delete', '删除课程《Demo课程》(#4)', '', '::1', '1419140220', 'info'), ('178', '1', 'course', 'delete', '删除课程《设计模式》(#3)', '', '::1', '1419140222', 'info'), ('179', '1', 'course', 'delete', '删除课程《如何成为屌丝》(#2)', '', '::1', '1419140224', 'info'), ('180', '1', 'course', 'delete', '删除课程《装逼培训》(#1)', '', '::1', '1419140226', 'info'), ('181', '1', 'review', 'delete', '删除评价#2', '', '::1', '1419140242', 'info'), ('182', '1', 'review', 'delete', '删除评价#1', '', '::1', '1419140242', 'info'), ('183', '1', 'thread', 'delete', '删除话题 我不想装逼，我只想显摆(2)', '', '::1', '1419140246', 'info'), ('184', '1', 'thread', 'delete', '删除话题 这哥们在讲什么呢(1)', '', '::1', '1419140246', 'info'), ('185', '1', 'category', 'delete', '删除分类人力资源(#2)', '', '::1', '1419140283', 'info'), ('186', '1', 'category', 'delete', '删除分类默认分类(#1)', '', '::1', '1419140287', 'info'), ('187', '1', 'tag', 'delete', '编辑标签#1', '', '::1', '1419140293', 'info'), ('188', '1', 'user', 'lock', '封禁用户凌峰(#4)', '', '::1', '1419140320', 'info'), ('189', '1', 'user', 'unlock', '解禁用户凌峰(#4)', '', '::1', '1419140324', 'info'), ('190', '1', 'user', 'cancel_recommend', '取消推荐用户熊先生(#1)', '', '::1', '1419140330', 'info'), ('191', '1', 'user', 'approval_fail', '用户阿蓝实名认证失败，操作人:熊先生 !', '', '::1', '1419140336', 'info'), ('192', '1', 'user', 'approval_fail', '用户熊先生实名认证失败，操作人:熊先生 !', '', '::1', '1419140338', 'info'), ('193', '1', 'Article', 'delete', '文章#2永久删除', '', '::1', '1419140487', 'info'), ('194', '1', 'Article', 'delete', '文章#1永久删除', '', '::1', '1419140487', 'info'), ('195', '1', 'user', 'login_success', '登录成功', '', '::1', '1419142189', 'info'), ('196', '1', 'user', 'login_success', '登录成功', '', '192.168.1.113', '1419149367', 'info'), ('197', '1', 'user', 'login_success', '登录成功', '', '::1', '1419427683', 'info'), ('198', '1', 'user', 'login_success', '登录成功', '', '::1', '1419427922', 'info'), ('199', '1', 'course', 'create', '创建课程《如何成为一名合格的程序员》(#1)', '', '::1', '1419427974', 'info'), ('200', '1', 'course', 'update', '更新课程《如何成为一名合格的程序员》(#1)的信息', '{\"title\":\"\\u5982\\u4f55\\u6210\\u4e3a\\u4e00\\u540d\\u5408\\u683c\\u7684\\u7a0b\\u5e8f\\u5458\",\"subtitle\":\"\\u7a0b\\u5e8f\\u5458\\u521d\\u7ea7\\u5165\\u95e8\\u8bfe\\u7a0b\",\"expiryDay\":30,\"showStudentNumType\":\"opened\",\"serializeMode\":\"none\",\"categoryId\":0,\"tags\":\"\"}', '::1', '1419428006', 'info'), ('201', '1', 'course', 'update', '更新课程《如何成为一名合格的程序员》(#1)的信息', '{\"about\":\"<p>\\n\\t<strong>\\u62d6\\u5ef6\\u75c7\\u201d\\u8fd9\\u4e2a\\u540d\\u8bcd\\u8fd1\\u4e9b\\u5e74\\u5f88\\u706b\\uff0c\\u4f3c\\u4e4e\\u6bcf\\u4e2a\\u4eba\\u90fd\\u89c9\\u5f97\\u81ea\\u5df1\\u7684\\u6548\\u7387\\u4e0d\\u9ad8\\uff0c\\u5f88\\u96be\\u96c6\\u4e2d\\u6ce8\\u610f\\u529b\\u505a\\u597d\\u624b\\u5934\\u7684\\u4e8b\\uff0c\\u90a3\\u6211\\u4eec\\u7a76\\u7adf\\u8be5\\u5982\\u4f55\\u63d0\\u9ad8\\u81ea\\u5df1\\u7684\\u5de5\\u4f5c\\u6548\\u7387\\u5462\\uff0c\\u5927\\u725b\\u6765\\u544a\\u8bc9\\u4f60.<\\/strong>\\n<\\/p>\\n<p>\\n\\tAaron Swartz\\u5199\\u8fc7\\u4e00\\u7bc7\\u5f88\\u6709\\u540d\\u7684\\u6587\\u7ae0\\uff0c\\u53eb\\u505a\\\"<a href=\\\"http:\\/\\/www.aaronsw.com\\/weblog\\/productivity\\\">HOWTO: Be more productive\\\"<\\/a>\\uff0c\\u8fd9\\u7bc7\\u6587\\u7ae0\\u5199\\u7684\\u5b9e\\u5728\\u662f\\u592a\\u597d\\u4e86\\uff0c\\u6211\\u770b\\u4e86\\u597d\\u591a\\u904d\\uff0c\\u5f88\\u8d5e\\u540c\\u4f5c\\u8005\\u7684\\u89c2\\u70b9\\u3002\\u6211\\u501f\\u9274\\u4e86\\u4f5c\\u8005\\u63d0\\u5230\\u7684\\u4e00\\u4e9b\\u65b9\\u6cd5\\u5e76\\u8fd0\\u7528\\u5230\\u81ea\\u5df1\\u7684\\u751f\\u6d3b\\u4e2d\\uff0c\\u53d1\\u73b0\\u786e\\u5b9e\\u6709\\u6548\\u679c\\uff0c\\u6240\\u4ee5\\u6211\\u613f\\u610f\\u8ba9\\u66f4\\u591a\\u7684\\u4eba\\u770b\\u5230\\u8fd9\\u7bc7\\u6587\\u7ae0\\u3002<a href=\\\"http:\\/\\/www.aaronsw.com\\/\\\">Aaron Swartz<\\/a>\\u8fd9\\u4e2a\\u4eba\\u7edd\\u5bf9\\u662f\\u5927\\u725b\\u4eba\\uff0c\\u4ed614\\u65f6\\u5c31\\u53c2\\u4e0e\\u4e86RSS1.0\\u7684\\u5236\\u5b9a\\uff0c\\u4ed6\\u5728Stanford\\u8bfb\\u4e86\\u4e00\\u5e74\\u5c31\\u4e3b\\u52a8\\u9000\\u5b66\\u4e86\\uff0c\\u6210\\u4e3a\\u4e86YC\\u7684\\u4e00\\u5458\\uff0c\\u4ed6\\u7684\\u516c\\u53f8\\u540e\\u6765\\u4e0ereddit\\u5408\\u5e76\\u4e86\\uff0c\\u4ed6\\u8fd8\\u662fweb.py\\u6846\\u67b6\\u7684\\u521b\\u59cb\\u4eba\\u3002<br \\/>\\n\\u5e9f\\u8bdd\\u5c11\\u8bf4\\uff0c\\u4e0b\\u9762\\u5c31\\u662f\\u8bd1\\u6587:<br \\/>\\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br \\/>\\n\\u80af\\u5b9a\\u6709\\u4eba\\u8ddf\\u4f60\\u8bf4\\u8fc7\\u8fd9\\u6837\\u7684\\u8bdd\\u201c\\u4f60\\u6709\\u770b\\u7535\\u89c6\\u7684\\u90a3\\u4e48\\u957f\\u65f6\\u95f4\\uff0c\\u90fd\\u53ef\\u4ee5\\u7528\\u6765\\u5199\\u4e00\\u672c\\u4e66\\u4e86\\u201d\\uff0c\\u4e0d\\u53ef\\u5426\\u8ba4\\u5199\\u4e66\\u80af\\u5b9a\\u6bd4\\u770b\\u7535\\u89c6\\u66f4\\u597d\\u7684\\u5229\\u7528\\u4e86\\u65f6\\u95f4\\uff0c\\u4f46\\u662f\\u8fd9\\u4e2a\\u7ed3\\u8bba\\u7684\\u6210\\u7acb\\u9700\\u8981\\u4e00\\u4e2a\\u5047\\u8bbe:\\\"\\u65f6\\u95f4\\u662f\\u53ef\\u4e92\\u6362\\u7684\\\"\\uff0c\\u4e5f\\u5c31\\u662f\\u8bf4\\u770b\\u7535\\u89c6\\u7684\\u65f6\\u95f4\\u53ef\\u4ee5\\u8f7b\\u677e\\u7684\\u7528\\u6765\\u5199\\u4e66\\u3002\\u4f46\\u662f\\u5f88\\u9057\\u61be\\uff0c\\u4e8b\\u5b9e\\u5e76\\u975e\\u5982\\u6b64\\u3002\\n<\\/p>\",\"goals\":[\"\\u6210\\u4e3a\\u4e00\\u540d\\u5408\\u683c\\u7684\\u7a0b\\u5e8f\\u5458\"],\"audiences\":[\"\\u4e0d\\u5408\\u683c\\u7684\\u7a0b\\u5e8f\\u5458\"]}', '::1', '1419428086', 'info'), ('202', '1', 'course', 'update_picture', '更新课程《如何成为一名合格的程序员》(#1)图片', '{\"smallPicture\":\"public:\\/\\/course\\/2014\\/12-24\\/213717daaa6e245477.jpg\",\"middlePicture\":\"public:\\/\\/course\\/2014\\/12-24\\/213717da8db7039793.jpg\",\"largePicture\":\"public:\\/\\/course\\/2014\\/12-24\\/213717d94689097699.jpg\"}', '::1', '1419428237', 'info'), ('203', '1', 'course', 'add_lesson', '添加课时《程序员学习第一课》(1)', '{\"id\":\"1\",\"courseId\":\"1\",\"chapterId\":\"0\",\"number\":\"1\",\"seq\":\"1\",\"free\":\"1\",\"status\":\"published\",\"title\":\"\\u7a0b\\u5e8f\\u5458\\u5b66\\u4e60\\u7b2c\\u4e00\\u8bfe\",\"summary\":\"\\u80af\\u5b9a\\u6709\\u4eba\\u8ddf\\u4f60\\u8bf4\\u8fc7\\u8fd9\\u6837\\u7684\\u8bdd\\u201c\\u4f60\\u6709\\u770b\\u7535\\u89c6\\u7684\\u90a3\\u4e48\\u957f\\u65f6\\u95f4\\uff0c\\u90fd\\u53ef\\u4ee5\\u7528\\u6765\\u5199\\u4e00\\u672c\\u4e66\\u4e86\\u201d\\uff0c\\u4e0d\\u53ef\\u5426\\u8ba4\\u5199\\u4e66\\u80af\\u5b9a\\u6bd4\\u770b\\u7535\\u89c6\\u66f4\\u597d\\u7684\\u5229\\u7528\\u4e86\\u65f6\\u95f4\\uff0c\\u4f46\\u662f\\u8fd9\\u4e2a\\u7ed3\\u8bba\\u7684\\u6210\\u7acb\\u9700\\u8981\\u4e00\\u4e2a\\u5047\\u8bbe:\\\"\\u65f6\\u95f4\\u662f\\u53ef\\u4e92\\u6362\\u7684\\\"\\uff0c\\u4e5f\\u5c31\\u662f\\u8bf4\\u770b\\u7535\\u89c6\\u7684\\u65f6\\u95f4\\u53ef\\u4ee5\\u8f7b\\u677e\\u7684\\u7528\\u6765\\u5199\\u4e66\\u3002\\u4f46\\u662f\\u5f88\\u9057\\u61be\\uff0c\\u4e8b\\u5b9e\\u5e76\\u975e\\u5982\\u6b64\\u3002\\r\\n\\u4e0d\\u540c\\u7684\\u65f6\\u95f4\\u6709\\u4e0d\\u540c\\u7684\\u8d28\\u91cf\\u7b49\\u7ea7\\u3002\\u5982\\u679c\\u6211\\u5728\\u8d70\\u5411\\u5730\\u94c1\\u7ad9\\u7684\\u8def\\u4e0a\\u53d1\\u73b0\\u81ea\\u5df1\\u7684\\u7b14\\u8bb0\\u672c\\u5fd8\\u5e26\\u4e86\\uff0c\\u6211\\u5c31\\u5f88\\u96be\\u96c6\\u4e2d\\u6ce8\\u610f\\u529b\\u5199\\u6587\\u7ae0\\u3002\\u540c\\u6837\\uff0c\\u5f53\\u4f60\\u4e0d\\u505c\\u7684\\u88ab\\u6253\\u65ad\\u7684\\u65f6\\u5019\\uff0c\\u4f60\\u4e5f\\u5f88\\u96be\\u96c6\\u4e2d\\u6ce8\\u610f\\u529b\\u3002\\u8fd9\\u91cc\\u8fd8\\u6709\\u4e00\\u4e9b\\u5fc3\\u7406\\u548c\\u60c5\\u611f\\u4e0a\\u7684\\u56e0\\u7d20\\uff0c\\u6709\\u7684\\u65f6\\u5019\\u6211\\u5fc3\\u60c5\\u5f88\\u597d\\uff0c\\u613f\\u610f\\u4e3b\\u52a8\\u53bb\\u505a\\u4e00\\u4e9b\\u4e8b\\uff0c\\u4f46\\u8fd8\\u6709\\u4e00\\u4e9b\\u65f6\\u5019\\u6211\\u611f\\u5230\\u5f88\\u6291\\u90c1\\u548c\\u75b2\\u60eb\\uff0c\\u5c31\\u53ea\\u80fd\\u770b\\u770b\\u7535\\u89c6\\u4e86\\u3002\\r\\n\\u5982\\u679c\\u4f60\\u60f3\\u53d8\\u7684\\u66f4\\u52a0\\u6709\\u6548\\u7387\\uff0c\\u4f60\\u5fc5\\u987b\\u610f\\u8bc6\\u5230\\u8fd9\\u4e2a\\u4e8b\\u5b9e\\uff0c\\u5e76\\u4e14\\u5f88\\u597d\\u7684\\u5904\\u7406\\u5b83\\u3002\\u9996\\u5148\\uff0c\\u4f60\\u5fc5\\u987b\\u5f88\\u597d\\u7684\\u5229\\u7528\\u4e0d\\u540c\\u79cd\\u7c7b\\u7684\\u65f6\\u95f4\\u3002\\u5176\\u6b21\\uff0c\\u4f60\\u5fc5\\u987b\\u8ba9\\u4f60\\u7684\\u65f6\\u95f4\\u66f4\\u6709\\u6548\\u7387\\u3002\",\"tags\":null,\"type\":\"text\",\"content\":\"<p>\\r\\n\\t<strong>\\u66f4\\u6709\\u6548\\u7684\\u5229\\u7528\\u4f60\\u7684\\u65f6\\u95f4<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u9009\\u62e9\\u5408\\u9002\\u7684\\u95ee\\u9898<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u751f\\u547d\\u662f\\u5982\\u6b64\\u7684\\u77ed\\u6682\\uff0c\\u4e3a\\u4ec0\\u4e48\\u6d6a\\u8d39\\u65f6\\u95f4\\u505a\\u4e00\\u4e9b\\u6ca1\\u610f\\u4e49\\u7684\\u4e8b\\u5462\\uff1f\\u505a\\u4e00\\u4e9b\\u8ba9\\u4f60\\u611f\\u5230\\u8212\\u9002\\u7684\\u4e8b\\u5f88\\u5bb9\\u6613\\uff0c\\u4f46\\u662f\\u4f60\\u5e94\\u8be5\\u95ee\\u95ee\\u81ea\\u5df1\\u4e3a\\u4ec0\\u4e48\\u8981\\u505a\\u8fd9\\u4e9b\\u4e8b\\u5462\\uff1f\\u6709\\u6ca1\\u6709\\u4e00\\u4e9b\\u66f4\\u91cd\\u8981\\u7684\\u4e8b\\u7b49\\u7740\\u4f60\\u53bb\\u505a\\uff1f\\u4e3a\\u4ec0\\u4e48\\u4f60\\u4e0d\\u53bb\\u505a\\u90a3\\u4e9b\\u4e8b\\u5462\\uff1f\\u8fd9\\u4e9b\\u95ee\\u9898\\u5f88\\u96be\\u56de\\u7b54\\uff0c\\u4f46\\u662f\\u6bcf\\u89e3\\u51b3\\u4e00\\u4e2a\\u90fd\\u4f1a\\u8ba9\\u4f60\\u66f4\\u6709\\u6548\\u7387\\u3002<br \\/>\\r\\n\\u8fd9\\u4e0d\\u662f\\u8bf4\\u4f60\\u6240\\u6709\\u7684\\u65f6\\u95f4\\u90fd\\u5e94\\u8be5\\u7528\\u6765\\u505a\\u90a3\\u4e9b\\u6700\\u91cd\\u8981\\u7684\\u4e8b\\u3002\\u6211\\u7684\\u65f6\\u95f4\\u5c31\\u80af\\u5b9a\\u4e0d\\u662f\\u8fd9\\u6837(\\u5426\\u5219\\uff0c\\u6211\\u73b0\\u5728\\u5c31\\u4e0d\\u4f1a\\u5728\\u5199\\u8fd9\\u7bc7\\u6587\\u7ae0\\u4e86)\\u3002\\u4f46\\u662f\\uff0c\\u8fd9\\u662f\\u6211\\u8861\\u91cf\\u81ea\\u5df1\\u7684\\u751f\\u6d3b\\u662f\\u5426\\u5145\\u5b9e\\u7684\\u91cd\\u8981\\u6807\\u51c6\\u3002\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u6536\\u96c6\\u5f88\\u591a\\u95ee\\u9898<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u53e6\\u4e00\\u4e2a\\u5f88\\u591a\\u4eba\\u90fd\\u77e5\\u9053\\u7684\\u79d8\\u5bc6\\u662f\\uff1a\\u5982\\u679c\\u4f60\\u8ba4\\u51c6\\u4e00\\u4e2a\\u95ee\\u9898\\uff0c\\u6295\\u5165\\u5168\\u90e8\\u7cbe\\u529b\\u53bb\\u89e3\\u51b3\\u5b83\\uff0c\\u8fd9\\u6837\\u4f60\\u7684\\u6548\\u7387\\u662f\\u6700\\u9ad8\\u7684\\u3002\\u6211\\u53d1\\u73b0\\u8fd9\\u5374\\u662f\\u5f88\\u96be\\u5b9e\\u73b0\\u7684\\u3002\\u4ee5\\u73b0\\u5728\\u4e3a\\u4f8b\\uff0c\\u6211\\u6b63\\u5728\\u953b\\u70bc\\u8eab\\u4f53\\uff0c\\u559d\\u6a59\\u6c41\\uff0c\\u6574\\u7406\\u684c\\u9762\\uff0c\\u548c\\u6211\\u5f1f\\u5f1f\\u804a\\u5929\\uff0c\\u540c\\u65f6\\u5728\\u5199\\u73b0\\u5728\\u8fd9\\u7bc7\\u6587\\u7ae0\\u3002\\u4eca\\u5929\\u4e00\\u6574\\u5929\\uff0c\\u6211\\u5199\\u4e86\\u73b0\\u5728\\u8fd9\\u7bc7\\u6587\\u7ae0\\uff0c\\u8bfb\\u4e86\\u4e00\\u672c\\u4e66\\uff0c\\u5403\\u4e86\\u70b9\\u4e1c\\u897f\\uff0c\\u56de\\u590d\\u4e86\\u51e0\\u5c01\\u90ae\\u4ef6\\uff0c\\u548c\\u4e00\\u4e9b\\u670b\\u53cb\\u804a\\u4e86\\u804a\\u5929\\uff0c\\u4e70\\u4e86\\u70b9\\u4e1c\\u897f\\uff0c\\u6539\\u4e86\\u6539\\u5176\\u4ed6\\u51e0\\u7bc7\\u6587\\u7ae0\\uff0c\\u5907\\u4efd\\u4e86\\u786c\\u76d8\\uff0c\\u8fd8\\u6574\\u7406\\u4e86\\u4e00\\u4e0b\\u56fe\\u4e66\\u5217\\u8868\\u3002<br \\/>\\r\\n\\u6709\\u5f88\\u591a\\u4e0d\\u540c\\u7684\\u9879\\u76ee\\u8ba9\\u6211\\u80fd\\u591f\\u5728\\u4e0d\\u540c\\u8d28\\u91cf\\u7684\\u65f6\\u95f4\\u4e0b\\u505a\\u4e0d\\u540c\\u7684\\u5de5\\u4f5c\\u3002\\u66f4\\u91cd\\u8981\\u7684\\u662f\\uff0c\\u5728\\u4f60\\u5361\\u58f3\\u6216\\u662f\\u538c\\u70e6\\u7684\\u65f6\\u5019\\u6709\\u5176\\u4ed6\\u7684\\u4e00\\u4e9b\\u4e8b\\u53ef\\u4ee5\\u505a\\u3002<br \\/>\\r\\n\\u8fd9\\u540c\\u65f6\\u4f1a\\u8ba9\\u4f60\\u53d8\\u5f97\\u66f4\\u52a0\\u6709\\u521b\\u9020\\u529b\\u3002\\u521b\\u9020\\u529b\\u5c31\\u662f\\u4f60\\u628a\\u81ea\\u5df1\\u4ece\\u5176\\u4ed6\\u5730\\u65b9\\u5b66\\u5230\\u7684\\u4e1c\\u897f\\u80fd\\u591f\\u7528\\u5230\\u4f60\\u7684\\u5de5\\u4f5c\\u4e2d\\u3002\\u5982\\u679c\\u4f60\\u540c\\u65f6\\u505a\\u8bb8\\u591a\\u4e0d\\u540c\\u65b9\\u5411\\u7684\\u5de5\\u4f5c\\uff0c\\u90a3\\u4f60\\u5c31\\u4f1a\\u5f97\\u5230\\u66f4\\u591a\\u7684\\u60f3\\u6cd5\\u548c\\u521b\\u610f\\u3002\\r\\n<\\/p>\",\"giveCredit\":\"0\",\"requireCredit\":\"0\",\"mediaId\":\"0\",\"mediaSource\":\"\",\"mediaName\":\"\",\"mediaUri\":\"\",\"length\":null,\"materialNum\":\"0\",\"quizNum\":\"0\",\"learnedNum\":\"0\",\"viewedNum\":\"0\",\"startTime\":\"0\",\"endTime\":\"0\",\"memberNum\":\"0\",\"replayStatus\":\"ungenerated\",\"userId\":\"1\",\"createdTime\":\"1419428459\"}', '::1', '1419428459', 'info'), ('204', '1', 'course', 'add_lesson', '添加课时《程序员学习第二课》(2)', '{\"id\":\"2\",\"courseId\":\"1\",\"chapterId\":\"0\",\"number\":\"2\",\"seq\":\"2\",\"free\":\"0\",\"status\":\"published\",\"title\":\"\\u7a0b\\u5e8f\\u5458\\u5b66\\u4e60\\u7b2c\\u4e8c\\u8bfe\",\"summary\":\"\\u80af\\u5b9a\\u6709\\u4eba\\u8ddf\\u4f60\\u8bf4\\u8fc7\\u8fd9\\u6837\\u7684\\u8bdd\\u201c\\u4f60\\u6709\\u770b\\u7535\\u89c6\\u7684\\u90a3\\u4e48\\u957f\\u65f6\\u95f4\\uff0c\\u90fd\\u53ef\\u4ee5\\u7528\\u6765\\u5199\\u4e00\\u672c\\u4e66\\u4e86\\u201d\\uff0c\\u4e0d\\u53ef\\u5426\\u8ba4\\u5199\\u4e66\\u80af\\u5b9a\\u6bd4\\u770b\\u7535\\u89c6\\u66f4\\u597d\\u7684\\u5229\\u7528\\u4e86\\u65f6\\u95f4\\uff0c\\u4f46\\u662f\\u8fd9\\u4e2a\\u7ed3\\u8bba\\u7684\\u6210\\u7acb\\u9700\\u8981\\u4e00\\u4e2a\\u5047\\u8bbe:\\\"\\u65f6\\u95f4\\u662f\\u53ef\\u4e92\\u6362\\u7684\\\"\\uff0c\\u4e5f\\u5c31\\u662f\\u8bf4\\u770b\\u7535\\u89c6\\u7684\\u65f6\\u95f4\\u53ef\\u4ee5\\u8f7b\\u677e\\u7684\\u7528\\u6765\\u5199\\u4e66\\u3002\\u4f46\\u662f\\u5f88\\u9057\\u61be\\uff0c\\u4e8b\\u5b9e\\u5e76\\u975e\\u5982\\u6b64\\u3002\\r\\n\\u4e0d\\u540c\\u7684\\u65f6\\u95f4\\u6709\\u4e0d\\u540c\\u7684\\u8d28\\u91cf\\u7b49\\u7ea7\\u3002\\u5982\\u679c\\u6211\\u5728\\u8d70\\u5411\\u5730\\u94c1\\u7ad9\\u7684\\u8def\\u4e0a\\u53d1\\u73b0\\u81ea\\u5df1\\u7684\\u7b14\\u8bb0\\u672c\\u5fd8\\u5e26\\u4e86\\uff0c\\u6211\\u5c31\\u5f88\\u96be\\u96c6\\u4e2d\\u6ce8\\u610f\\u529b\\u5199\\u6587\\u7ae0\\u3002\\u540c\\u6837\\uff0c\\u5f53\\u4f60\\u4e0d\\u505c\\u7684\\u88ab\\u6253\\u65ad\\u7684\\u65f6\\u5019\\uff0c\\u4f60\\u4e5f\\u5f88\\u96be\\u96c6\\u4e2d\\u6ce8\\u610f\\u529b\\u3002\\u8fd9\\u91cc\\u8fd8\\u6709\\u4e00\\u4e9b\\u5fc3\\u7406\\u548c\\u60c5\\u611f\\u4e0a\\u7684\\u56e0\\u7d20\\uff0c\\u6709\\u7684\\u65f6\\u5019\\u6211\\u5fc3\\u60c5\\u5f88\\u597d\\uff0c\\u613f\\u610f\\u4e3b\\u52a8\\u53bb\\u505a\\u4e00\\u4e9b\\u4e8b\\uff0c\\u4f46\\u8fd8\\u6709\\u4e00\\u4e9b\\u65f6\\u5019\\u6211\\u611f\\u5230\\u5f88\\u6291\\u90c1\\u548c\\u75b2\\u60eb\\uff0c\\u5c31\\u53ea\\u80fd\\u770b\\u770b\\u7535\\u89c6\\u4e86\\u3002\\r\\n\\u5982\\u679c\\u4f60\\u60f3\\u53d8\\u7684\\u66f4\\u52a0\\u6709\\u6548\\u7387\\uff0c\\u4f60\\u5fc5\\u987b\\u610f\\u8bc6\\u5230\\u8fd9\\u4e2a\\u4e8b\\u5b9e\\uff0c\\u5e76\\u4e14\\u5f88\\u597d\\u7684\\u5904\\u7406\\u5b83\\u3002\\u9996\\u5148\\uff0c\\u4f60\\u5fc5\\u987b\\u5f88\\u597d\\u7684\\u5229\\u7528\\u4e0d\\u540c\\u79cd\\u7c7b\\u7684\\u65f6\\u95f4\\u3002\\u5176\\u6b21\\uff0c\\u4f60\\u5fc5\\u987b\\u8ba9\\u4f60\\u7684\\u65f6\\u95f4\\u66f4\\u6709\\u6548\\u7387\\u3002\",\"tags\":null,\"type\":\"text\",\"content\":\"<p>\\r\\n\\t<strong>\\u5217\\u4e00\\u4e2a\\u6e05\\u5355<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u627e\\u4e00\\u4e9b\\u4e0d\\u540c\\u7684\\u4e8b\\u540c\\u65f6\\u505a\\u5e76\\u4e0d\\u56f0\\u96be\\uff0c\\u5927\\u90e8\\u5206\\u4eba\\u90fd\\u6709\\u5f88\\u591a\\u5f88\\u591a\\u7684\\u5f85\\u529e\\u4e8b\\u9879\\u3002\\u4f46\\u662f\\u5982\\u679c\\u4f60\\u60f3\\u628a\\u5b83\\u4eec\\u5168\\u8bb0\\u5728\\u8111\\u888b\\u91cc\\u7684\\u8bdd\\uff0c\\u5b83\\u4eec\\u5c31\\u4f1a\\u6162\\u6162\\u6d88\\u5931\\u3002\\u8981\\u8bb0\\u4f4f\\u6240\\u6709\\u8fd9\\u4e9b\\u4e8b\\u6240\\u7ed9\\u4f60\\u5e26\\u6765\\u7684\\u5fc3\\u667a\\u4e0a\\u7684\\u538b\\u529b\\u4f1a\\u628a\\u4f60\\u538b\\u57ae\\u3002\\u89e3\\u51b3\\u529e\\u6cd5\\u4ecd\\u7136\\u662f\\u5f88\\u7b80\\u5355\\uff1a\\u628a\\u5b83\\u4eec\\u5199\\u4e0b\\u6765\\u3002<br \\/>\\r\\n\\u4e00\\u65e6\\u4f60\\u628a\\u8981\\u505a\\u7684\\u4e8b\\u5217\\u6210\\u4e86\\u4e00\\u4e2a\\u6e05\\u5355\\uff0c\\u4f60\\u5c31\\u53ef\\u4ee5\\u66f4\\u597d\\u7684\\u5206\\u7c7b\\u7ec4\\u7ec7\\u5b83\\u4eec\\u4e86\\u3002\\u6bd4\\u5982\\u8bf4\\uff0c\\u6211\\u7684\\u6e05\\u5355\\u5305\\u62ec\\uff1a\\u7f16\\u7a0b\\uff0c\\u601d\\u8003\\uff0c\\u5dee\\u4e8b\\uff0c\\u8bfb\\u4e66\\uff0c\\u5a31\\u4e50\\u4f11\\u606f\\u3002<br \\/>\\r\\n\\u5927\\u90e8\\u5206\\u9879\\u76ee\\u90fd\\u5305\\u62ec\\u5f88\\u591a\\u4e0d\\u540c\\u7684\\u4efb\\u52a1\\u3002\\u4ee5\\u5199\\u8fd9\\u7bc7\\u6587\\u7ae0\\u4e3a\\u4f8b\\uff0c\\u9664\\u4e86\\u771f\\u6b63\\u7684\\u5199\\u4f5c\\u8fc7\\u7a0b\\uff0c\\u8fd8\\u5305\\u62ec\\u4e86\\u9605\\u8bfb\\u5176\\u4ed6\\u5173\\u4e8e\\u62d6\\u6c93\\u7684\\u6587\\u7ae0\\uff0c\\u8003\\u8651\\u6587\\u7ae0\\u7684\\u5404\\u4e2a\\u90e8\\u5206\\uff0c\\u6574\\u7406\\u8bed\\u53e5\\uff0c\\u5411\\u522b\\u4eba\\u8bf7\\u6559\\u95ee\\u9898\\u7b49\\u7b49\\u3002\\u6bcf\\u4e00\\u9879\\u4efb\\u52a1\\u90fd\\u5c5e\\u4e8e\\u6e05\\u5355\\u7684\\u4e0d\\u540c\\u90e8\\u5206\\uff0c\\u6240\\u4ee5\\u4f60\\u53ef\\u4ee5\\u5728\\u5408\\u9002\\u7684\\u65f6\\u95f4\\u624d\\u53bb\\u505a\\u67d0\\u4e00\\u90e8\\u5206\\u3002\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u628a\\u4efb\\u52a1\\u6e05\\u5355\\u548c\\u4f60\\u7684\\u751f\\u6d3b\\u7ed3\\u5408\\u8d77\\u6765<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u4e00\\u65e6\\u4f60\\u6709\\u4e86\\u8fd9\\u6837\\u4e00\\u4e2a\\u4efb\\u52a1\\u6e05\\u5355\\uff0c\\u4f60\\u9700\\u8981\\u505a\\u7684\\u4e8b\\u5c31\\u662f\\u65f6\\u5e38\\u8bb0\\u5f97\\u5b83\\uff0c\\u800c\\u8bb0\\u4f4f\\u5b83\\u7684\\u6700\\u597d\\u65b9\\u6cd5\\u662f\\u628a\\u5b83\\u653e\\u5728\\u4f60\\u80fd\\u770b\\u5230\\u7684\\u5730\\u65b9\\u3002\\u6bd4\\u5982\\u8bf4\\uff0c\\u6211\\u603b\\u5728\\u6211\\u684c\\u5b50\\u4e0a\\u653e\\u4e00\\u645e\\u4e66\\uff0c\\u6700\\u4e0a\\u9762\\u7684\\u90a3\\u4e00\\u672c\\u5c31\\u662f\\u6211\\u6700\\u8fd1\\u5728\\u8bfb\\u7684\\u3002\\u5f53\\u6211\\u60f3\\u8981\\u8bfb\\u4e66\\u7684\\u65f6\\u5019\\uff0c\\u6211\\u5c31\\u76f4\\u63a5\\u4ece\\u4e0a\\u9762\\u62ff\\u4e00\\u672c\\u4e66\\u6765\\u8bfb\\u3002<br \\/>\\r\\n\\u5bf9\\u4e8e\\u770b\\u7535\\u89c6\\/\\u7535\\u5f71\\u6211\\u4e5f\\u8fd9\\u4e48\\u505a\\u3002\\u5f53\\u6211\\u5bf9\\u67d0\\u4e00\\u4e2a\\u7535\\u5f71\\u611f\\u5174\\u8da3\\u7684\\u65f6\\u5019\\uff0c\\u6211\\u4f1a\\u628a\\u5b83\\u653e\\u5728\\u7535\\u8111\\u4e2d\\u4e00\\u4e2a\\u7279\\u6b8a\\u7684\\u6587\\u4ef6\\u5939\\u5185\\u3002\\u6bcf\\u5f53\\u6211\\u60f3\\u4f11\\u606f\\u4e00\\u4e0b\\uff0c\\u770b\\u770b\\u7535\\u5f71\\u7684\\u65f6\\u5019\\uff0c\\u6211\\u5c31\\u4f1a\\u6253\\u5f00\\u90a3\\u4e2a\\u6587\\u4ef6\\u5939\\u3002<br \\/>\\r\\n\\u6211\\u4e5f\\u60f3\\u8fc7\\u4e00\\u4e9b\\u66f4\\u6df1\\u5165\\u7684\\u65b9\\u5f0f\\uff0c\\u6bd4\\u5982\\u8bf4\\u6211\\u628a\\u4e00\\u4e9b\\u60f3\\u770b\\u7684\\u6587\\u7ae0\\u6807\\u8bb0\\u4e3a\\\"\\u5f85\\u8bfb\\\"(to read)\\uff0c\\u5f53\\u6211\\u60f3\\u8981\\u4e0a\\u7f51\\u7684\\u65f6\\u5019\\u5c31\\u770b\\u770b\\u90a3\\u4e9b\\u4ece\\u524d\\u79ef\\u7d2f\\u4e0b\\u6765\\u7684\\u672a\\u8bfb\\u6587\\u7ae0\\u3002\\r\\n<\\/p>\",\"giveCredit\":\"0\",\"requireCredit\":\"0\",\"mediaId\":\"0\",\"mediaSource\":\"\",\"mediaName\":\"\",\"mediaUri\":\"\",\"length\":null,\"materialNum\":\"0\",\"quizNum\":\"0\",\"learnedNum\":\"0\",\"viewedNum\":\"0\",\"startTime\":\"0\",\"endTime\":\"0\",\"memberNum\":\"0\",\"replayStatus\":\"ungenerated\",\"userId\":\"1\",\"createdTime\":\"1419428507\"}', '::1', '1419428507', 'info'), ('205', '1', 'course', 'add_lesson', '添加课时《程序员学习第三课》(3)', '{\"id\":\"3\",\"courseId\":\"1\",\"chapterId\":\"0\",\"number\":\"3\",\"seq\":\"3\",\"free\":\"0\",\"status\":\"published\",\"title\":\"\\u7a0b\\u5e8f\\u5458\\u5b66\\u4e60\\u7b2c\\u4e09\\u8bfe\",\"summary\":\"\\u80af\\u5b9a\\u6709\\u4eba\\u8ddf\\u4f60\\u8bf4\\u8fc7\\u8fd9\\u6837\\u7684\\u8bdd\\u201c\\u4f60\\u6709\\u770b\\u7535\\u89c6\\u7684\\u90a3\\u4e48\\u957f\\u65f6\\u95f4\\uff0c\\u90fd\\u53ef\\u4ee5\\u7528\\u6765\\u5199\\u4e00\\u672c\\u4e66\\u4e86\\u201d\\uff0c\\u4e0d\\u53ef\\u5426\\u8ba4\\u5199\\u4e66\\u80af\\u5b9a\\u6bd4\\u770b\\u7535\\u89c6\\u66f4\\u597d\\u7684\\u5229\\u7528\\u4e86\\u65f6\\u95f4\\uff0c\\u4f46\\u662f\\u8fd9\\u4e2a\\u7ed3\\u8bba\\u7684\\u6210\\u7acb\\u9700\\u8981\\u4e00\\u4e2a\\u5047\\u8bbe:\\\"\\u65f6\\u95f4\\u662f\\u53ef\\u4e92\\u6362\\u7684\\\"\\uff0c\\u4e5f\\u5c31\\u662f\\u8bf4\\u770b\\u7535\\u89c6\\u7684\\u65f6\\u95f4\\u53ef\\u4ee5\\u8f7b\\u677e\\u7684\\u7528\\u6765\\u5199\\u4e66\\u3002\\u4f46\\u662f\\u5f88\\u9057\\u61be\\uff0c\\u4e8b\\u5b9e\\u5e76\\u975e\\u5982\\u6b64\\u3002\\r\\n\\u4e0d\\u540c\\u7684\\u65f6\\u95f4\\u6709\\u4e0d\\u540c\\u7684\\u8d28\\u91cf\\u7b49\\u7ea7\\u3002\\u5982\\u679c\\u6211\\u5728\\u8d70\\u5411\\u5730\\u94c1\\u7ad9\\u7684\\u8def\\u4e0a\\u53d1\\u73b0\\u81ea\\u5df1\\u7684\\u7b14\\u8bb0\\u672c\\u5fd8\\u5e26\\u4e86\\uff0c\\u6211\\u5c31\\u5f88\\u96be\\u96c6\\u4e2d\\u6ce8\\u610f\\u529b\\u5199\\u6587\\u7ae0\\u3002\\u540c\\u6837\\uff0c\\u5f53\\u4f60\\u4e0d\\u505c\\u7684\\u88ab\\u6253\\u65ad\\u7684\\u65f6\\u5019\\uff0c\\u4f60\\u4e5f\\u5f88\\u96be\\u96c6\\u4e2d\\u6ce8\\u610f\\u529b\\u3002\\u8fd9\\u91cc\\u8fd8\\u6709\\u4e00\\u4e9b\\u5fc3\\u7406\\u548c\\u60c5\\u611f\\u4e0a\\u7684\\u56e0\\u7d20\\uff0c\\u6709\\u7684\\u65f6\\u5019\\u6211\\u5fc3\\u60c5\\u5f88\\u597d\\uff0c\\u613f\\u610f\\u4e3b\\u52a8\\u53bb\\u505a\\u4e00\\u4e9b\\u4e8b\\uff0c\\u4f46\\u8fd8\\u6709\\u4e00\\u4e9b\\u65f6\\u5019\\u6211\\u611f\\u5230\\u5f88\\u6291\\u90c1\\u548c\\u75b2\\u60eb\\uff0c\\u5c31\\u53ea\\u80fd\\u770b\\u770b\\u7535\\u89c6\\u4e86\\u3002\\r\\n\\u5982\\u679c\\u4f60\\u60f3\\u53d8\\u7684\\u66f4\\u52a0\\u6709\\u6548\\u7387\\uff0c\\u4f60\\u5fc5\\u987b\\u610f\\u8bc6\\u5230\\u8fd9\\u4e2a\\u4e8b\\u5b9e\\uff0c\\u5e76\\u4e14\\u5f88\\u597d\\u7684\\u5904\\u7406\\u5b83\\u3002\\u9996\\u5148\\uff0c\\u4f60\\u5fc5\\u987b\\u5f88\\u597d\\u7684\\u5229\\u7528\\u4e0d\\u540c\\u79cd\\u7c7b\\u7684\\u65f6\\u95f4\\u3002\\u5176\\u6b21\\uff0c\\u4f60\\u5fc5\\u987b\\u8ba9\\u4f60\\u7684\\u65f6\\u95f4\\u66f4\\u6709\\u6548\\u7387\\u3002\",\"tags\":null,\"type\":\"text\",\"content\":\"<p>\\r\\n\\t<strong>\\u63d0\\u9ad8\\u4f60\\u65f6\\u95f4\\u7684\\u8d28\\u91cf<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u50cf\\u4e0a\\u9762\\u90a3\\u6837\\u6700\\u5927\\u9650\\u5ea6\\u7684\\u5229\\u7528\\u65f6\\u95f4\\u8fd8\\u8fdc\\u8fdc\\u4e0d\\u591f\\uff0c\\u66f4\\u91cd\\u8981\\u7684\\u662f\\u63d0\\u9ad8\\u4f60\\u81ea\\u5df1\\u7684\\u65f6\\u95f4\\u7684\\u8d28\\u91cf\\u3002\\u90a3\\u4f60\\u7a76\\u7adf\\u8be5\\u600e\\u6837\\u505a\\u5462\\uff1f\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u51cf\\u8f7b\\u8eab\\u4f53\\u4e0a\\u7684\\u7ea6\\u675f<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u643a\\u5e26\\u7eb8\\u548c\\u7b14<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u6211\\u8ba4\\u8bc6\\u7684\\u5f88\\u591a\\u4eba\\u7684\\u53e3\\u888b\\u91cc\\u90fd\\u6709\\u8bb0\\u4e8b\\u7c3f\\u4e4b\\u7c7b\\u7684\\u4e1c\\u897f\\u3002\\u7eb8\\u548c\\u7b14\\u5728\\u5f88\\u591a\\u65f6\\u5019\\u90fd\\u662f\\u975e\\u5e38\\u6709\\u7528\\u7684\\uff0c\\u4f60\\u53ef\\u4ee5\\u968f\\u65f6\\u968f\\u523b\\u7684\\u8bb0\\u5f55\\u81ea\\u5df1\\u7684\\u60f3\\u6cd5\\uff0c\\u6211\\u751a\\u81f3\\u901a\\u8fc7\\u8fd9\\u79cd\\u65b9\\u6cd5\\u5728\\u5730\\u94c1\\u4e0a\\u5199\\u8fc7\\u6574\\u7bc7\\u6587\\u7ae0\\u3002\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u907f\\u514d\\u88ab\\u6253\\u6270<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u5bf9\\u4e8e\\u90a3\\u4e9b\\u9700\\u8981\\u96c6\\u4e2d\\u6ce8\\u610f\\u529b\\u7684\\u4efb\\u52a1\\uff0c\\u4f60\\u5e94\\u8be5\\u5c3d\\u91cf\\u907f\\u514d\\u88ab\\u6253\\u6270\\u3002\\u4e00\\u4e2a\\u5f88\\u7b80\\u5355\\u7684\\u65b9\\u6cd5\\u662f\\u53bb\\u4e00\\u4e2a\\u6ca1\\u4eba\\u80fd\\u6253\\u6270\\u4f60\\u7684\\u5730\\u65b9\\uff0c\\u53e6\\u4e00\\u4e2a\\u65b9\\u6cd5\\u662f\\u544a\\u8bc9\\u5468\\u56f4\\u7684\\u4eba\\u672a\\u6765\\u4e00\\u6bb5\\u65f6\\u95f4\\u4e0d\\u8981\\u6253\\u6270\\u4f60\\u3002<br \\/>\\r\\n\\u5173\\u4e8e\\u8fd9\\u70b9\\u4e0d\\u8981\\u8fc7\\u72b9\\u4e0d\\u53ca\\u3002\\u5f53\\u4f60\\u5728\\u6d6a\\u8d39\\u65f6\\u95f4\\u7684\\u65f6\\u5019\\u4f60\\u53cd\\u5012\\u5e94\\u8be5\\u88ab\\u6253\\u6270\\u4e00\\u4e0b\\uff0c\\u5e2e\\u52a9\\u522b\\u4eba\\u89e3\\u51b3\\u95ee\\u9898\\u80af\\u5b9a\\u6bd4\\u5750\\u5728\\u90a3\\u91cc\\u770b\\u65b0\\u95fb\\u66f4\\u597d\\u7684\\u5229\\u7528\\u4e86\\u65f6\\u95f4\\u3002\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u51cf\\u8f7b\\u5fc3\\u7406\\u4e0a\\u7684\\u7ea6\\u675f<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u5403\\uff0c\\u7761\\uff0c\\u8fd0\\u52a8<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u5f53\\u4f60\\u611f\\u5230\\u5f88\\u997f\\uff0c\\u5f88\\u7d2f\\uff0c\\u5f88\\u7126\\u8e81\\u7684\\u65f6\\u5019\\uff0c\\u4f60\\u7684\\u65f6\\u95f4\\u7684\\u8d28\\u91cf\\u4f1a\\u5f88\\u4f4e\\u3002\\u89e3\\u51b3\\u8fd9\\u4e2a\\u95ee\\u9898\\u5f88\\u7b80\\u5355\\uff0c\\u5c31\\u662f\\uff1a\\u53bb\\u5403\\uff0c\\u53bb\\u7761\\uff0c\\u53bb\\u8fd0\\u52a8\\u3002\\u5bf9\\u81ea\\u5df1\\u8bf4\\u201c\\u867d\\u7136\\u6211\\u5f88\\u7d2f\\u4e86\\uff0c\\u4f46\\u6211\\u4e0d\\u80fd\\u4f11\\u606f\\uff0c\\u56e0\\u4e3a\\u6211\\u5fc5\\u987b\\u8981\\u5de5\\u4f5c\\u201d\\u4f1a\\u8ba9\\u4f60\\u611f\\u5230\\u81ea\\u5df1\\u5f88\\u52aa\\u529b\\uff0c\\u4f46\\u4e8b\\u5b9e\\u4e0a\\u4f11\\u606f\\u4e4b\\u540e\\u4f60\\u7684\\u6548\\u7387\\u4f1a\\u66f4\\u9ad8\\u3002\\u65e2\\u7136\\u4f60\\u8fdf\\u65e9\\u90fd\\u8981\\u7761\\u89c9\\uff0c\\u8fd8\\u4e0d\\u5982\\u5148\\u4f11\\u606f\\u597d\\uff0c\\u6765\\u63d0\\u9ad8\\u5269\\u4f59\\u65f6\\u95f4\\u5185\\u7684\\u6548\\u7387\\u3002\\r\\n<\\/p>\",\"giveCredit\":\"0\",\"requireCredit\":\"0\",\"mediaId\":\"0\",\"mediaSource\":\"\",\"mediaName\":\"\",\"mediaUri\":\"\",\"length\":null,\"materialNum\":\"0\",\"quizNum\":\"0\",\"learnedNum\":\"0\",\"viewedNum\":\"0\",\"startTime\":\"0\",\"endTime\":\"0\",\"memberNum\":\"0\",\"replayStatus\":\"ungenerated\",\"userId\":\"1\",\"createdTime\":\"1419428535\"}', '::1', '1419428535', 'info'), ('206', '1', 'course', 'add_lesson', '添加课时《程序员学习第四课》(4)', '{\"id\":\"4\",\"courseId\":\"1\",\"chapterId\":\"0\",\"number\":\"4\",\"seq\":\"4\",\"free\":\"0\",\"status\":\"published\",\"title\":\"\\u7a0b\\u5e8f\\u5458\\u5b66\\u4e60\\u7b2c\\u56db\\u8bfe\",\"summary\":\"\\u7b2c\\u56db\\u8bfe\\u6458\\u8981\",\"tags\":null,\"type\":\"text\",\"content\":\"<p>\\r\\n\\t<strong>\\u4e0e\\u5feb\\u4e50\\u7684\\u4eba\\u76f8\\u5904<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u8ddf\\u5feb\\u4e50\\u7684\\u4eba\\u76f8\\u5904\\u4f1a\\u4e5f\\u4f1a\\u8ba9\\u4f60\\u53d8\\u5f97\\u5feb\\u4e50\\uff0c\\u4e5f\\u4f1a\\u8ba9\\u4f60\\u5fc3\\u6001\\u66f4\\u653e\\u677e\\u3002\\u4e5f\\u8bb8\\u5f88\\u591a\\u4eba\\u613f\\u610f\\u8eb2\\u5728\\u5c4b\\u5b50\\u91cc\\uff0c\\u4e0d\\u4e0e\\u5176\\u4ed6\\u4eba\\u63a5\\u89e6\\uff0c\\u57cb\\u5934\\u5e72\\u6d3b\\uff0c\\u4ed6\\u4eec\\u89c9\\u5f97\\u8fd9\\u6837\\u7684\\u8bdd\\u65f6\\u95f4\\u624d\\u6ca1\\u6709\\u88ab\\u201c\\u6d6a\\u8d39\\u201d\\uff0c\\u4f46\\u4e8b\\u5b9e\\u4e0a\\u8fd9\\u4f1a\\u8ba9\\u4ed6\\u4eec\\u53d8\\u5f97\\u60c5\\u7eea\\u4f4e\\u843d\\uff0c\\u5de5\\u4f5c\\u6548\\u7387\\u4e5f\\u4f1a\\u5927\\u5927\\u4e0b\\u964d\\u3002\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u4e0e\\u670b\\u53cb\\u5206\\u62c5\\u4f60\\u7684\\u538b\\u529b<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u5373\\u4f7f\\u4f60\\u7684\\u670b\\u53cb\\u5e76\\u4e0d\\u662f\\u80fd\\u591f\\u611f\\u67d3\\u4ed6\\u4eba\\uff0c\\u7ed9\\u4f60\\u5e26\\u6765\\u5feb\\u4e50\\u7684\\u90a3\\u79cd\\u4eba\\uff0c\\u548c\\u5176\\u4ed6\\u7684\\u4eba\\u4e00\\u8d77\\u89e3\\u51b3\\u590d\\u6742\\u7684\\u95ee\\u9898\\u4e5f\\u4f1a\\u8ba9\\u95ee\\u9898\\u53d8\\u5f97\\u7b80\\u5355\\u3002\\u4e00\\u65b9\\u9762\\uff0c\\u7cbe\\u795e\\u4e0a\\u7684\\u538b\\u529b\\u5927\\u5bb6\\u53ef\\u4ee5\\u4e92\\u76f8\\u5206\\u62c5\\uff0c\\u53e6\\u4e00\\u65b9\\u9762\\uff0c\\u548c\\u5176\\u4ed6\\u4eba\\u5728\\u4e00\\u8d77\\u53ef\\u4ee5\\u8ba9\\u4f60\\u4e13\\u6ce8\\u4e8e\\u5de5\\u4f5c\\u800c\\u4e0d\\u662f\\u65f6\\u5e38\\u5206\\u5fc3\\u3002\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u62d6\\u6c93<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u4e0a\\u9762\\u6240\\u8bf4\\u7684\\u90a3\\u4e9b\\u5e76\\u4e0d\\u662f\\u95ee\\u9898\\u7684\\u91cd\\u70b9\\uff0c\\u5173\\u4e8e\\u6548\\u7387\\u5927\\u5bb6\\u6700\\u5927\\u7684\\u95ee\\u9898\\u8fd8\\u662f\\u201c\\u62d6\\u6c93\\u201d\\u3002\\u867d\\u7136\\u5f88\\u591a\\u4eba\\u4e0d\\u627f\\u8ba4\\uff0c\\u4f46\\u662f\\u51e0\\u4e4e\\u6240\\u6709\\u4eba\\u90fd\\u6216\\u591a\\u6216\\u5c11\\u7684\\u4f1a\\u62d6\\u6c93\\u3002\\u90a3\\u53c8\\u8be5\\u5982\\u4f55\\u907f\\u514d\\u5462\\uff1f<br \\/>\\r\\n\\u62d6\\u6c93\\u662f\\u4ec0\\u4e48\\uff1f\\u4ece\\u65c1\\u89c2\\u8005\\u6765\\u770b\\uff0c\\u4f60\\u5728\\u505a\\u597d\\u73a9\\u7684\\u4e8b(\\u5982\\u73a9\\u6e38\\u620f\\uff0c\\u770b\\u65b0\\u95fb)\\u800c\\u4e0d\\u662f\\u505a\\u771f\\u6b63\\u7684\\u5de5\\u4f5c\\u3002\\u4f46\\u95ee\\u9898\\u7684\\u5173\\u952e\\u662f\\uff1a\\u4f60\\u7a76\\u7adf\\u4e3a\\u4ec0\\u4e48\\u4f1a\\u8fd9\\u6837\\uff1f\\u4f60\\u7684\\u8111\\u5b50\\u91cc\\u7a76\\u7adf\\u662f\\u600e\\u4e48\\u60f3\\u7684\\uff1f<br \\/>\\r\\n\\u6211\\u82b1\\u4e86\\u5f88\\u591a\\u65f6\\u95f4\\u6765\\u7814\\u7a76\\u8fd9\\u4ef6\\u4e8b\\uff0c\\u6211\\u80fd\\u7ed9\\u51fa\\u7684\\u6700\\u597d\\u89e3\\u91ca\\u662f\\u5728\\u4f60\\u7684\\u5927\\u8111\\u8d4b\\u4e88\\u201c\\u8111\\u529b\\u573a\\u201d\\u7ed9\\u6bcf\\u4e00\\u9879\\u4efb\\u52a1\\u3002\\u4f60\\u73a9\\u8fc7\\u4e24\\u5757\\u78c1\\u94c1\\u76f8\\u4e92\\u4f5c\\u7528\\u5417\\uff1f\\u5982\\u679c\\u4f60\\u8ba9\\u5b83\\u4eec\\u5f02\\u6781\\u76f8\\u5bf9\\uff0c\\u4ed6\\u4eec\\u5c31\\u4f1a\\u76f8\\u4e92\\u6392\\u65a5\\uff0c\\u4f60\\u4f1a\\u611f\\u5230\\u4ed6\\u4eec\\u4e4b\\u95f4\\u7684\\u78c1\\u573a\\u529b\\u3002\\u4f60\\u8d8a\\u662f\\u60f3\\u8981\\u628a\\u5b83\\u4eec\\u548c\\u5728\\u4e00\\u8d77\\uff0c\\u8d8a\\u4f1a\\u611f\\u5230\\u5b83\\u4eec\\u4e4b\\u95f4\\u7684\\u6392\\u65a5\\u529b\\u3002<br \\/>\\r\\n\\u5fc3\\u667a\\u548c\\u7cbe\\u795e\\u4e0a\\u4e5f\\u662f\\u7c7b\\u4f3c\\u7684\\u3002\\u5b83\\u662f\\u770b\\u4e0d\\u89c1\\u6478\\u4e0d\\u7740\\u7684\\uff0c\\u4f46\\u4f60\\u5374\\u53ef\\u4ee5\\u611f\\u53d7\\u5230\\u5b83\\u7684\\u5b58\\u5728\\u3002\\u5e76\\u4e14\\u4f60\\u8d8a\\u662f\\u60f3\\u8981\\u63a5\\u8fd1\\u5b83\\uff0c\\u5b83\\u4f1a\\u79bb\\u4f60\\u8d8a\\u8fdc\\u3002<br \\/>\\r\\n\\u4f60\\u4e0d\\u53ef\\u80fd\\u901a\\u8fc7\\u86ee\\u529b\\u6765\\u514b\\u670d\\u4e24\\u4e2a\\u573a\\u4e4b\\u95f4\\u7684\\u6392\\u65a5\\u529b\\uff0c\\u76f8\\u53cd\\uff0c\\u4f60\\u5e94\\u8be5\\u505a\\u7684\\u662f\\u8c03\\u8f6c\\u65b9\\u5411\\u3002<br \\/>\\r\\n\\u90a3\\u53c8\\u662f\\u4ec0\\u4e48\\u4ea7\\u751f\\u4e86\\u201c\\u7cbe\\u795e\\u529b\\u573a\\u201d\\u5462\\uff1f\\u4f3c\\u4e4e\\u6709\\u4e24\\u4e2a\\u4e3b\\u8981\\u539f\\u56e0\\uff1a\\u4efb\\u52a1\\u662f\\u5426\\u8270\\u5de8\\uff0c\\u4efb\\u52a1\\u662f\\u5426\\u662f\\u88ab\\u6307\\u6d3e\\u7684\\u3002\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u8270\\u5de8\\u7684\\u4efb\\u52a1<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u628a\\u4efb\\u52a1\\u7ec6\\u5206<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u4e00\\u4e2a\\u4efb\\u52a1\\u5f88\\u8270\\u5de8\\u7684\\u539f\\u56e0\\u4e4b\\u4e00\\u662f\\u8fd9\\u4e2a\\u4efb\\u52a1\\u5f88\\u5b8f\\u5927\\u3002\\u6bd4\\u5982\\u8bf4\\u4f60\\u60f3\\u8981\\u505a\\u4e00\\u4e2a\\u83dc\\u8c31\\u6784\\u9020\\u7a0b\\u5e8f\\uff0c\\u6ca1\\u6709\\u4eba\\u80fd\\u4e00\\u4e0b\\u5b50\\u5b8c\\u6210\\u5b83\\uff0c\\u8fd9\\u662f\\u4e00\\u4e2a\\u76ee\\u6807\\u800c\\u4e0d\\u662f\\u4e00\\u9879\\u4efb\\u52a1\\u3002\\u4e00\\u9879\\u4efb\\u52a1\\u662f\\u4f7f\\u4f60\\u80fd\\u591f\\u671d\\u5411\\u76ee\\u6807\\u66f4\\u8fdb\\u4e00\\u6b65\\u7684\\u5177\\u4f53\\u6982\\u5ff5\\u3002\\u4e00\\u4e2a\\u597d\\u7684\\u4efb\\u52a1\\u662f\\u4f60\\u80fd\\u591f\\u7acb\\u5373\\u62ff\\u6765\\u5b9e\\u65bd\\u7684\\uff0c\\u6bd4\\u5982\\\"\\u753b\\u4e00\\u4e2a\\u5c55\\u793a\\u83dc\\u8c31\\u7684\\u8349\\u56fe\\\"\\u3002<br \\/>\\r\\n\\u5f53\\u4f60\\u5b8c\\u6210\\u4e86\\u4e0a\\u4e00\\u4e2a\\u4efb\\u52a1\\u540e\\uff0c\\u4e0b\\u4e00\\u6b65\\u5c31\\u4f1a\\u53d8\\u5f97\\u66f4\\u52a0\\u6e05\\u6670\\u3002\\u4f60\\u5c06\\u4f1a\\u8003\\u8651\\u4e00\\u4e2a\\u83dc\\u8c31\\u6709\\u4ec0\\u4e48\\u6784\\u6210\\uff0c\\u4f60\\u9700\\u8981\\u4ec0\\u4e48\\u6837\\u7684\\u641c\\u7d22\\u673a\\u5236\\uff0c\\u5982\\u4f55\\u6784\\u5efa\\u83dc\\u8c31\\u7684\\u6570\\u636e\\u5e93\\uff0c\\u7b49\\u7b49\\u3002\\u8fd9\\u6837\\u4f60\\u5c31\\u6784\\u5efa\\u4e86\\u4e00\\u4e2a\\u5f15\\u64ce\\uff0c\\u6bcf\\u4e00\\u4e2a\\u4efb\\u52a1\\u90fd\\u4f1a\\u901a\\u5411\\u4e0b\\u4e00\\u4e2a\\u4efb\\u52a1\\u3002<br \\/>\\r\\n\\u5bf9\\u4e8e\\u6bcf\\u4e00\\u4e2a\\u6bd4\\u8f83\\u5927\\u7684\\u9879\\u76ee\\uff0c\\u6211\\u90fd\\u4f1a\\u8003\\u8651\\u6211\\u9700\\u8981\\u5b8c\\u6210\\u4e00\\u8fde\\u4e32\\u4ec0\\u4e48\\u6837\\u7684\\u4efb\\u52a1\\uff0c\\u5e76\\u4e14\\u5c06\\u8fd9\\u4e9b\\u4efb\\u52a1\\u52a0\\u5165\\u5230\\u6211\\u7684\\u5f85\\u529e\\u4e8b\\u9879\\u5217\\u8868\\u4e2d\\u53bb\\u3002\\u540c\\u6837\\uff0c\\u5f53\\u6211\\u505a\\u5b8c\\u4e00\\u4e9b\\u4efb\\u52a1\\u4e4b\\u540e\\u6211\\u4f1a\\u628a\\u63a5\\u4e0b\\u6765\\u9700\\u8981\\u5b8c\\u6210\\u7684\\u4efb\\u52a1\\u518d\\u52a0\\u5165\\u4efb\\u52a1\\u5217\\u8868\\u4e2d\\u53bb\\u3002\\r\\n<\\/p>\",\"giveCredit\":\"0\",\"requireCredit\":\"0\",\"mediaId\":\"0\",\"mediaSource\":\"\",\"mediaName\":\"\",\"mediaUri\":\"\",\"length\":null,\"materialNum\":\"0\",\"quizNum\":\"0\",\"learnedNum\":\"0\",\"viewedNum\":\"0\",\"startTime\":\"0\",\"endTime\":\"0\",\"memberNum\":\"0\",\"replayStatus\":\"ungenerated\",\"userId\":\"1\",\"createdTime\":\"1419428568\"}', '::1', '1419428568', 'info'), ('207', '1', 'course', 'add_lesson', '添加课时《程序员学习第五课》(5)', '{\"id\":\"5\",\"courseId\":\"1\",\"chapterId\":\"0\",\"number\":\"5\",\"seq\":\"5\",\"free\":\"0\",\"status\":\"published\",\"title\":\"\\u7a0b\\u5e8f\\u5458\\u5b66\\u4e60\\u7b2c\\u4e94\\u8bfe\",\"summary\":\"\\u7b2c\\u4e94\\u8bfe\\u6458\\u8981\",\"tags\":null,\"type\":\"text\",\"content\":\"<p>\\r\\n\\t<strong>\\u7b80\\u5316\\u4efb\\u52a1<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u53e6\\u4e00\\u4e2a\\u8ba9\\u4efb\\u52a1\\u53d8\\u5f97\\u8270\\u5de8\\u7684\\u539f\\u56e0\\u5c31\\u662f\\u5b83\\u592a\\u590d\\u6742\\u4e86\\u3002\\\"\\u5199\\u4e00\\u672c\\u4e66\\\"\\u8fd9\\u4e2a\\u4efb\\u52a1\\u4f1a\\u653e\\u4f60\\u611f\\u5230\\u65e0\\u4ece\\u4e0b\\u624b\\uff0c\\u90a3\\u4e48\\u5c31\\u5148\\u4ece\\u5199\\u4e00\\u7bc7\\u6587\\u7ae0\\u5f00\\u59cb\\u5427\\u3002\\u5982\\u679c\\u4e00\\u7bc7\\u6587\\u7ae0\\u4e5f\\u89c9\\u5f97\\u592a\\u591a\\u4e86\\uff0c\\u90a3\\u4e48\\u5c31\\u5148\\u5199\\u4e00\\u4e2a\\u6bb5\\u843d\\u7684\\u6982\\u8981\\u5427\\u3002\\u6700\\u91cd\\u8981\\u7684\\u662f\\u771f\\u6b63\\u505a\\u4e86\\u4e00\\u4e9b\\u5de5\\u4f5c\\uff0c\\u771f\\u6b63\\u7684\\u6709\\u8fdb\\u5c55\\u3002<br \\/>\\r\\n\\u4e00\\u65e6\\u4f60\\u660e\\u786e\\u4e86\\u4f60\\u7684\\u4efb\\u52a1\\u4e4b\\u540e\\uff0c\\u4f60\\u5c31\\u53ef\\u4ee5\\u66f4\\u6e05\\u695a\\u7684\\u5224\\u65ad\\u5b83\\uff0c\\u66f4\\u5bb9\\u6613\\u7684\\u7406\\u89e3\\u5b83\\u3002\\u63d0\\u9ad8\\u5b8c\\u5584\\u4e00\\u4e9b\\u5df2\\u6709\\u7684\\u4e1c\\u897f\\u6bd4\\u4ece\\u5934\\u521b\\u5efa\\u4e1c\\u897f\\u66f4\\u5bb9\\u6613\\u3002\\u5982\\u679c\\u4f60\\u7684\\u4e00\\u4e2a\\u6bb5\\u843d\\u5199\\u597d\\u4e86\\uff0c\\u90a3\\u4e48\\u4e00\\u70b9\\u4e00\\u70b9\\u79ef\\u7d2f\\uff0c\\u5b83\\u4f1a\\u53d8\\u6210\\u4e00\\u7bc7\\u6587\\u7ae0\\uff0c\\u6700\\u7ec8\\u53d8\\u6210\\u4e00\\u672c\\u4e66\\u3002\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u8ba4\\u771f\\u8003\\u8651\\u5b83<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u901a\\u5e38\\u6765\\u8bf4\\u89e3\\u51b3\\u4e00\\u4e2a\\u56f0\\u96be\\u95ee\\u9898\\u9700\\u8981\\u4e00\\u4e9b\\u7075\\u611f\\u3002\\u5982\\u679c\\u4f60\\u5bf9\\u90a3\\u4e2a\\u9886\\u57df\\u5e76\\u4e0d\\u719f\\u6089\\uff0c\\u4f60\\u5e94\\u8be5\\u4ece\\u7814\\u7a76\\u8fd9\\u4e2a\\u9886\\u57df\\u5f00\\u59cb\\uff0c\\u501f\\u9274\\u4e00\\u4e0b\\u5176\\u4ed6\\u4eba\\u7684\\u7ecf\\u9a8c\\uff0c\\u6162\\u6162\\u7684\\u7814\\u7a76\\u7406\\u89e3\\u8fd9\\u4e2a\\u9886\\u57df\\uff0c\\u5e76\\u4e14\\u505a\\u4e00\\u4e9b\\u5c0f\\u7684\\u5c1d\\u8bd5\\u770b\\u770b\\u4f60\\u80fd\\u5426\\u641e\\u5b9a\\u8fd9\\u4e2a\\u9886\\u57df\\u3002\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u88ab\\u6307\\u6d3e\\u7684\\u4efb\\u52a1<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u88ab\\u6307\\u6d3e\\u7684\\u4efb\\u52a1\\u662f\\u90a3\\u4e9b\\u4f60\\u88ab\\u8981\\u6c42\\u5b8c\\u6210\\u7684\\u4efb\\u52a1\\u3002\\u5f88\\u591a\\u5fc3\\u7406\\u5b66\\u5b9e\\u9a8c\\u90fd\\u8868\\u660e:\\u5f53\\u4f60\\\"\\u523a\\u6fc0\\\"\\u5176\\u4ed6\\u4eba\\u505a\\u4ec0\\u4e48\\u4e8b\\u7684\\u65f6\\u5019\\uff0c\\u4ed6\\u4eec\\u53cd\\u5012\\u4e0d\\u5bb9\\u6613\\u505a\\u597d\\u90a3\\u4e2a\\u4e8b\\u3002\\u5956\\u52b1\\uff0c\\u60e9\\u7f5a\\u7b49\\u5916\\u90e8\\u523a\\u6fc0\\u4f1a\\u627c\\u6740\\\"\\u5185\\u5728\\u52a8\\u673a\\\"--\\u4f60\\u5bf9\\u4e8e\\u67d0\\u4e2a\\u95ee\\u9898\\u53d1\\u81ea\\u5185\\u5fc3\\u7684\\u5174\\u8da3\\u3002\\u4eba\\u7c7b\\u7684\\u5927\\u8111\\u5bf9\\u4e8e\\u88ab\\u8981\\u6c42\\u505a\\u7684\\u4e8b\\u6709\\u5148\\u5929\\u7684\\u6297\\u62d2\\u529b\\u3002<br \\/>\\r\\n\\u8fd9\\u79cd\\u73b0\\u8c61\\u4e0d\\u4ec5\\u5c40\\u9650\\u4e8e\\u5176\\u4ed6\\u4eba\\u8981\\u6c42\\u4f60\\u505a\\u7684\\u4e8b\\uff0c\\u5f53\\u4f60\\u5411\\u81ea\\u5df1\\u5206\\u914d\\u4efb\\u52a1\\u65f6\\u4ecd\\u7136\\u4f1a\\u51fa\\u73b0\\u8fd9\\u79cd\\u73b0\\u8c61\\u3002\\u5982\\u679c\\u4f60\\u5bf9\\u81ea\\u5df1\\u8bf4\\\"\\u6211\\u5e94\\u8be5\\u597d\\u597d\\u505aX\\u5de5\\u4f5c\\u4e86\\uff0c\\u8fd9\\u662f\\u6211\\u73b0\\u5728\\u6700\\u91cd\\u8981\\u7684\\u4e8b\\\"\\uff0c\\u4e4b\\u540e\\u4f60\\u5c31\\u4f1a\\u611f\\u5230X\\u7a81\\u7136\\u53d8\\u6210\\u4e86\\u4e16\\u754c\\u4e0a\\u6700\\u56f0\\u96be\\u7684\\u4e8b\\u60c5\\u4e86\\u3002\\u7136\\u800c\\u4e00\\u65e6\\u5f53Y\\u53d8\\u6210\\u4e86\\\"\\u6700\\u91cd\\u8981\\u7684\\u4e8b\\\"\\uff0c\\u539f\\u6765\\u7684\\u90a3\\u4e2aX\\u53c8\\u53d8\\u5f97\\u7b80\\u5355\\u4e86\\u3002\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u865a\\u6784\\u4e00\\u4e2a\\u4efb\\u52a1<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u5982\\u679c\\u4f60\\u8981\\u5b8c\\u6210X\\uff0c\\u90a3\\u5c31\\u544a\\u8bc9\\u81ea\\u5df1\\u505aY\\u3002\\u7136\\u800c\\u4e0d\\u5e78\\u7684\\u662f\\uff0c\\u8fd9\\u6837\\u6b3a\\u9a97\\u81ea\\u5df1\\u5374\\u5f88\\u96be\\uff0c\\u56e0\\u4e3a\\u4f60\\u6e05\\u695a\\u4f60\\u7a76\\u7adf\\u8981\\u505a\\u4ec0\\u4e48\\u3002\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u4e0d\\u8981\\u81ea\\u5df1\\u7ed9\\u81ea\\u5df1\\u5e03\\u7f6e\\u4efb\\u52a1<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u7ed9\\u81ea\\u5df1\\u5e03\\u7f6e\\u4efb\\u52a1\\u770b\\u8d77\\u6765\\u5f88\\u8bf1\\u4eba\\uff0c\\u6bd4\\u5982\\u5bf9\\u81ea\\u5df1\\u8bf4\\\"\\u6211\\u8981\\u5199\\u5b8c\\u8fd9\\u7bc7\\u6587\\u7ae0\\u624d\\u53bb\\u5403\\u996d\\\"\\uff0c\\u66f4\\u7cdf\\u7cd5\\u7684\\u662f\\u8ba9\\u522b\\u4eba\\u5047\\u88c5\\u5e03\\u7f6e\\u7ed9\\u4f60\\u4e00\\u4e9b\\u4efb\\u52a1\\u3002\\u4f46\\u662f\\u8fd9\\u4e24\\u79cd\\u65b9\\u5f0f\\u90fd\\u4f1a\\u8ba9\\u4f60\\u53d8\\u5f97\\u66f4\\u6ca1\\u6709\\u6548\\u7387\\uff0c\\u4e8b\\u5b9e\\u4e0a\\u4f60\\u8fd8\\u662f\\u5728\\u7ed9\\u81ea\\u5df1\\u5e03\\u7f6e\\u4efb\\u52a1\\uff0c\\u4f60\\u7684\\u5927\\u8111\\u53ea\\u4f1a\\u53bb\\u9003\\u907f\\u5b83\\u3002\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u628a\\u4e8b\\u60c5\\u53d8\\u5f97\\u6709\\u8da3<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u56f0\\u96be\\u7684\\u5de5\\u4f5c\\u542c\\u8d77\\u6765\\u4e0d\\u4f1a\\u4ee4\\u4eba\\u611f\\u5230\\u6109\\u60a6\\uff0c\\u4f46\\u4e8b\\u5b9e\\u4e0a\\u8fd9\\u53ef\\u80fd\\u5c31\\u662f\\u6700\\u80fd\\u8ba9\\u6211\\u611f\\u5230\\u9ad8\\u5174\\u7684\\u4e8b\\u3002\\u4e00\\u4e2a\\u56f0\\u96be\\u7684\\u95ee\\u9898\\u4e0d\\u4f46\\u80fd\\u8ba9\\u4f60\\u96c6\\u4e2d\\u5168\\u90e8\\u6ce8\\u610f\\u529b\\uff0c\\u800c\\u4e14\\u5f53\\u4f60\\u5b8c\\u6210\\u5b83\\u7684\\u65f6\\u5019\\u4f60\\u4f1a\\u611f\\u5230\\u975e\\u5e38\\u68d2\\uff0c\\u975e\\u5e38\\u6709\\u6210\\u5c31\\u611f\\u3002<br \\/>\\r\\n\\u6240\\u4ee5\\u5e2e\\u52a9\\u81ea\\u5df1\\u5b8c\\u6210\\u4e00\\u4ef6\\u4e8b\\u7684\\u79d8\\u5bc6\\u4e0d\\u662f\\u8bf4\\u670d\\u81ea\\u5df1\\u5fc5\\u987b\\u5b8c\\u6210\\u5b83\\uff0c\\u800c\\u662f\\u8bf4\\u670d\\u81ea\\u5df1\\u8fd9\\u4ef6\\u4e8b\\u786e\\u5b9e\\u975e\\u5e38\\u6709\\u610f\\u601d\\u3002\\u5982\\u679c\\u4e00\\u4ef6\\u4e8b\\u6ca1\\u6709\\u610f\\u601d\\u7684\\u8bdd\\uff0c\\u4f60\\u9700\\u8981\\u505a\\u7684\\u5c31\\u662f\\u8ba9\\u5b83\\u53d8\\u5f97\\u6709\\u610f\\u601d\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t<strong>\\u603b\\u7ed3<\\/strong>\\r\\n<\\/p>\\r\\n<p>\\r\\n\\t\\u6548\\u7387\\u7684\\u771f\\u6b63\\u79d8\\u5bc6\\u5728\\u4e8e\\\"\\u8046\\u542c\\u81ea\\u5df1\\\"\\uff0c\\u5728\\u4f60\\u997f\\u7684\\u65f6\\u5019\\u5403\\u996d\\uff0c\\u5728\\u4f60\\u75b2\\u60eb\\u7684\\u65f6\\u5019\\u7761\\u89c9\\uff0c\\u5f53\\u4f60\\u538c\\u70e6\\u7684\\u65f6\\u5019\\u4f11\\u606f\\u4e00\\u4e0b\\uff0c\\u505a\\u90a3\\u4e9b\\u6709\\u8da3\\u597d\\u73a9\\u7684\\u9879\\u76ee\\u3002<br \\/>\\r\\n\\u8fd9\\u770b\\u8d77\\u6765\\u5f88\\u5bb9\\u6613\\uff0c\\u4f46\\u662f\\u793e\\u4f1a\\u4e0a\\u7684\\u4e00\\u4e9b\\u89c2\\u5ff5\\u6b63\\u5728\\u628a\\u6211\\u4eec\\u5411\\u76f8\\u53cd\\u7684\\u65b9\\u5411\\u5f15\\u5bfc\\u3002\\u8981\\u60f3\\u53d8\\u5f97\\u66f4\\u52a0\\u6709\\u6548\\u7387\\uff0c\\u6211\\u4eec\\u9700\\u8981\\u505a\\u7684\\u5c31\\u662f\\u8f6c\\u8fc7\\u5934\\u6765\\\"\\u8046\\u542c\\u81ea\\u5df1\\\"<a href=\\\"http:\\/\\/images.cnblogs.com\\/cnblogs_com\\/meng-meng\\/201111\\/20111117102128284.gif\\\"><img alt=\\\"clip_image001\\\" border=\\\"0\\\" height=\\\"2\\\" style=\\\"height:auto;\\\" title=\\\"clip_image001\\\" width=\\\"2\\\" src=\\\"cid:5db818d452f5fd1511ca71cce522a16f\\\" id=\\\"en-media:image\\/gif:5db818d452f5fd1511ca71cce522a16f:2:2\\\" \\/><\\/a>\\r\\n<\\/p>\",\"giveCredit\":\"0\",\"requireCredit\":\"0\",\"mediaId\":\"0\",\"mediaSource\":\"\",\"mediaName\":\"\",\"mediaUri\":\"\",\"length\":null,\"materialNum\":\"0\",\"quizNum\":\"0\",\"learnedNum\":\"0\",\"viewedNum\":\"0\",\"startTime\":\"0\",\"endTime\":\"0\",\"memberNum\":\"0\",\"replayStatus\":\"ungenerated\",\"userId\":\"1\",\"createdTime\":\"1419428591\"}', '::1', '1419428591', 'info');
INSERT INTO `log` VALUES ('208', '1', 'user', 'login_success', '登录成功', '', '::1', '1419471863', 'info'), ('209', '1', 'course', 'create', '熊先生观看课时《程序员学习第一课》', '', '::1', '1419471864', 'info'), ('210', '1', 'user', 'login_success', '登录成功', '', '::1', '1419481315', 'info'), ('211', '1', 'course', 'create', '熊先生观看课时《程序员学习第一课》', '', '::1', '1419481334', 'info'), ('212', '1', 'user', 'login_success', '登录成功', '', '::1', '1419481404', 'info'), ('213', '1', 'user', 'login_success', '登录成功', '', '::1', '1420646821', 'info'), ('214', '1', 'user', 'login_success', '登录成功', '', '::1', '1427293941', 'info'), ('215', '1', 'course', 'create', '熊先生观看课时《程序员学习第五课》', '', '::1', '1427294485', 'info'), ('216', '1', 'course', 'create', '熊先生观看课时《程序员学习第二课》', '', '::1', '1427294493', 'info'), ('217', '1', 'course', 'create', '熊先生观看课时《程序员学习第三课》', '', '::1', '1427294497', 'info'), ('218', '1', 'course', 'create', '熊先生观看课时《程序员学习第四课》', '', '::1', '1427294501', 'info'), ('219', '1', 'course', 'create', '熊先生观看课时《程序员学习第五课》', '', '::1', '1427294503', 'info'), ('220', '1', 'course', 'create', '熊先生观看课时《程序员学习第四课》', '', '::1', '1427294506', 'info'), ('221', '1', 'course', 'create', '熊先生观看课时《程序员学习第三课》', '', '::1', '1427294506', 'info'), ('222', '1', 'course', 'create', '熊先生观看课时《程序员学习第二课》', '', '::1', '1427294507', 'info'), ('223', '1', 'course', 'create', '熊先生观看课时《程序员学习第一课》', '', '::1', '1427294509', 'info'), ('224', '1', 'user', 'login_success', '登录成功', '', '::1', '1427334385', 'info'), ('225', '1', 'user', 'login_success', '登录成功', '', '::1', '1427336044', 'info'), ('226', '1', 'user', 'login_success', '登录成功', '', '::1', '1427338030', 'info'), ('227', '3', 'user', 'login_success', '登录成功', '', '::1', '1427339583', 'info'), ('228', '3', 'user', 'lock', '封禁用户熊先生(#1)', '', '::1', '1427339592', 'info'), ('229', '3', 'user', 'unlock', '解禁用户熊先生(#1)', '', '::1', '1427339597', 'info'), ('230', '3', 'user', 'login_success', '登录成功', '', '::1', '1427352697', 'info'), ('231', '3', 'user', 'login_success', '登录成功', '', '::1', '1427355540', 'info'), ('232', '1', 'user', 'login_success', '登录成功', '', '::1', '1427355574', 'info'), ('233', '1', 'user', 'login_success', '登录成功', '', '::1', '1427420325', 'info'), ('234', '4', 'user', 'login_fail', '用户名：凌峰，登录失败：帐号或密码不正确', '', '::1', '1427420606', 'info'), ('235', '4', 'user', 'login_success', '登录成功', '', '::1', '1427420614', 'info'), ('236', '1', 'user', 'login_success', '登录成功', '', '::1', '1427420652', 'info'), ('237', '1', 'course', 'publish', '发布课程《如何成为一名合格的程序员》(#1)', '', '::1', '1427420669', 'info'), ('238', '4', 'user', 'login_success', '登录成功', '', '::1', '1427420683', 'info'), ('239', '4', 'course', 'create', '凌峰观看课时《程序员学习第一课》', '', '::1', '1427420702', 'info'), ('240', '4', 'course', 'create', '凌峰观看课时《程序员学习第二课》', '', '::1', '1427420707', 'info'), ('241', '4', 'course', 'create', '凌峰观看课时《程序员学习第三课》', '', '::1', '1427420711', 'info'), ('242', '4', 'course', 'create', '凌峰观看课时《程序员学习第四课》', '', '::1', '1427420714', 'info'), ('243', '4', 'course', 'create', '凌峰观看课时《程序员学习第五课》', '', '::1', '1427420717', 'info'), ('244', '1', 'user', 'login_success', '登录成功', '', '::1', '1427420756', 'info'), ('245', '4', 'user', 'login_success', '登录成功', '', '::1', '1427421967', 'info'), ('246', '4', 'course', 'create', '凌峰观看课时《程序员学习第一课》', '', '::1', '1427422008', 'info'), ('247', '1', 'user', 'login_success', '登录成功', '', '::1', '1427427342', 'info'), ('248', '1', 'user', 'login_success', '登录成功', '', '::1', '1427436679', 'info');
COMMIT;

-- ----------------------------
--  Table structure for `message`
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '私信Id',
  `fromId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发信人Id',
  `toId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '收信人Id',
  `content` text NOT NULL COMMENT '私信内容',
  `createdTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '私信发送时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `message`
-- ----------------------------
BEGIN;
INSERT INTO `message` VALUES ('1', '1', '4', '凌峰,欢迎加入课程如何成为一名合格的程序员', '1427420697');
COMMIT;

-- ----------------------------
--  Table structure for `message_conversation`
-- ----------------------------
DROP TABLE IF EXISTS `message_conversation`;
CREATE TABLE `message_conversation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '会话Id',
  `fromId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发信人Id',
  `toId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '收信人Id',
  `messageNum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '此对话的信息条数',
  `latestMessageUserId` int(10) unsigned DEFAULT NULL COMMENT '最后发信人ID',
  `latestMessageTime` int(10) unsigned NOT NULL COMMENT '最后发信时间',
  `latestMessageContent` text NOT NULL COMMENT '最后发信内容',
  `unreadNum` int(10) unsigned NOT NULL COMMENT '未读数量',
  `createdTime` int(10) unsigned NOT NULL COMMENT '会话创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `message_conversation`
-- ----------------------------
BEGIN;
INSERT INTO `message_conversation` VALUES ('1', '4', '1', '1', '1', '1427420697', '凌峰,欢迎加入课程如何成为一名合格的程序员', '0', '1427420697'), ('2', '1', '4', '1', '1', '1427420697', '凌峰,欢迎加入课程如何成为一名合格的程序员', '1', '1427420697');
COMMIT;

-- ----------------------------
--  Table structure for `message_relation`
-- ----------------------------
DROP TABLE IF EXISTS `message_relation`;
CREATE TABLE `message_relation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '消息关联ID',
  `conversationId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '关联的会话ID',
  `messageId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '关联的消息ID',
  `isRead` enum('0','1') NOT NULL DEFAULT '0' COMMENT '是否已读',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `message_relation`
-- ----------------------------
BEGIN;
INSERT INTO `message_relation` VALUES ('1', '1', '1', '0'), ('2', '2', '1', '0');
COMMIT;

-- ----------------------------
--  Table structure for `migration_versions`
-- ----------------------------
DROP TABLE IF EXISTS `migration_versions`;
CREATE TABLE `migration_versions` (
  `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
--  Table structure for `mobile_device`
-- ----------------------------
DROP TABLE IF EXISTS `mobile_device`;
CREATE TABLE `mobile_device` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '设备ID',
  `imei` varchar(255) NOT NULL COMMENT '串号',
  `platform` varchar(255) NOT NULL COMMENT '平台',
  `version` varchar(255) NOT NULL COMMENT '版本',
  `screenresolution` varchar(100) NOT NULL COMMENT '分辨率',
  `kernel` varchar(255) NOT NULL COMMENT '内核',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `navigation`
-- ----------------------------
DROP TABLE IF EXISTS `navigation`;
CREATE TABLE `navigation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '导航ID',
  `name` varchar(255) NOT NULL COMMENT '导航名称',
  `url` varchar(300) NOT NULL COMMENT '链接地址',
  `sequence` tinyint(4) unsigned NOT NULL COMMENT '显示顺序',
  `parentId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父导航ID',
  `createdTime` int(11) NOT NULL COMMENT '创建时间',
  `updateTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后更新时间',
  `type` varchar(30) NOT NULL COMMENT '类型',
  `isOpen` tinyint(2) NOT NULL DEFAULT '1' COMMENT '默认1，为开启',
  `isNewWin` tinyint(2) NOT NULL DEFAULT '1' COMMENT '默认为1,另开窗口',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='导航数据表';

-- ----------------------------
--  Records of `navigation`
-- ----------------------------
BEGIN;
INSERT INTO `navigation` VALUES ('1', '师资力量', 'teacher', '1', '0', '1410920900', '1411054516', 'top', '1', '0'), ('2', '常见问题', 'page/questions', '3', '0', '1410920900', '1411054326', 'top', '1', '0'), ('3', '关于我们', 'page/aboutus', '4', '0', '1410920900', '1411054331', 'top', '1', '0'), ('4', '学习计划', 'www.baidu.com', '2', '0', '1411054242', '1411054242', 'top', '1', '1'), ('5', '个人学习计划', '', '2', '4', '1411054278', '1411056301', 'top', '1', '0'), ('6', '下属学习计划', '', '3', '4', '1411054300', '1411056307', 'top', '1', '0'), ('7', '底部导航', '', '1', '0', '1411054367', '1411054367', 'foot', '1', '0'), ('8', '记得联系我', '', '2', '0', '1411054402', '1411054402', 'foot', '1', '0'), ('9', '科技资讯', 'article', '5', '0', '1411055607', '1411055630', 'top', '1', '0'), ('10', '学习小组', 'group', '1', '4', '1411056293', '1411056293', 'top', '1', '0');
COMMIT;

-- ----------------------------
--  Table structure for `notification`
-- ----------------------------
DROP TABLE IF EXISTS `notification`;
CREATE TABLE `notification` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '通知ID',
  `userId` int(10) unsigned NOT NULL COMMENT '被通知的用户ID',
  `type` varchar(64) NOT NULL DEFAULT 'default' COMMENT '通知类型',
  `content` text COMMENT '通知内容',
  `createdTime` int(10) unsigned NOT NULL COMMENT '通知时间',
  `isRead` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已读',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `notification`
-- ----------------------------
BEGIN;
INSERT INTO `notification` VALUES ('1', '1', 'default', '{\"message\":\"\\u60a8\\u7684\\u4e2a\\u4eba\\u5b9e\\u540d\\u8ba4\\u8bc1\\uff0c\\u5ba1\\u6838\\u5df2\\u7ecf\\u901a\\u8fc7\\uff01(\\u4e0d\\u9519\\u4e0d\\u9519)\"}', '1410921095', '0'), ('2', '2', 'default', '{\"message\":\"\\u60a8\\u7684\\u4e2a\\u4eba\\u5b9e\\u540d\\u8ba4\\u8bc1\\uff0c\\u5ba1\\u6838\\u5df2\\u7ecf\\u901a\\u8fc7\\uff01\"}', '1411093492', '0'), ('3', '1', 'student-create', '{\"courseId\":\"2\",\"courseTitle\":\"\\u5982\\u4f55\\u6210\\u4e3a\\u5c4c\\u4e1d\"}', '1411095682', '0'), ('4', '3', 'student-create', '{\"courseId\":\"2\",\"courseTitle\":\"\\u5982\\u4f55\\u6210\\u4e3a\\u5c4c\\u4e1d\"}', '1411095692', '0'), ('5', '3', 'default', '{\"message\":\"\\u3010\\u8bfe\\u7a0b\\u516c\\u544a\\u3011\\u4f60\\u6b63\\u5728\\u5b66\\u4e60\\u7684<a href=\'http:\\/\\/localhost\\/edusoho\\/web\\/course\\/2\' target=\'_blank\'>\\u5982\\u4f55\\u6210\\u4e3a\\u5c4c\\u4e1d<\\/a>\\u53d1\\u5e03\\u4e86\\u4e00\\u4e2a\\u65b0\\u7684\\u516c\\u544a\\uff0c<a href=\'http:\\/\\/localhost\\/edusoho\\/web\\/course\\/2\' target=\'_blank\'>\\u5feb\\u53bb\\u770b\\u770b\\u5427<\\/a>\"}', '1411105852', '0'), ('6', '1', 'default', '{\"message\":\"\\u3010\\u8bfe\\u7a0b\\u516c\\u544a\\u3011\\u4f60\\u6b63\\u5728\\u5b66\\u4e60\\u7684<a href=\'http:\\/\\/localhost\\/edusoho\\/web\\/course\\/2\' target=\'_blank\'>\\u5982\\u4f55\\u6210\\u4e3a\\u5c4c\\u4e1d<\\/a>\\u53d1\\u5e03\\u4e86\\u4e00\\u4e2a\\u65b0\\u7684\\u516c\\u544a\\uff0c<a href=\'http:\\/\\/localhost\\/edusoho\\/web\\/course\\/2\' target=\'_blank\'>\\u5feb\\u53bb\\u770b\\u770b\\u5427<\\/a>\"}', '1411105852', '0'), ('7', '1', 'default', '{\"message\":\"\\u3010\\u8bd5\\u5377\\u5df2\\u5b8c\\u6210\\u3011 <a href=\'http:\\/\\/localhost\\/edusoho\\/web\\/user\\/2\' target=\'_blank\'>\\u963f\\u84dd<\\/a> \\u521a\\u521a\\u5b8c\\u6210\\u4e86 \\u88c5\\u903c\\u8003\\u8bd5 \\uff0c<a href=\'http:\\/\\/localhost\\/edusoho\\/web\\/test\\/1\\/teacher\\/check\' target=\'_blank\'>\\u8bf7\\u70b9\\u51fb\\u6279\\u9605<\\/a>\"}', '1411209214', '0'), ('8', '2', 'default', '{\"message\":\"\\u3010\\u8bd5\\u5377\\u5df2\\u6279\\u9605\\u3011 <a href=\'http:\\/\\/localhost\\/edusoho\\/web\\/user\\/1\' target=\'_blank\'>\\u718a\\u5148\\u751f<\\/a> \\u521a\\u521a\\u6279\\u9605\\u4e86 \\u88c5\\u903c\\u8003\\u8bd5 \\uff0c<a href=\'http:\\/\\/localhost\\/edusoho\\/web\\/test\\/1\\/result\' target=\'_blank\'>\\u8bf7\\u70b9\\u51fb\\u67e5\\u770b\\u7ed3\\u679c<\\/a>\"}', '1411209352', '0'), ('9', '1', 'default', '{\"message\":\"\\u8bfe\\u7a0b\\u300a\\u88c5\\u903c\\u57f9\\u8bad\\u300b\\u6709\\u65b0\\u95ee\\u9898 <a href=\'http:\\/\\/localhost\\/edusoho\\/web\\/course\\/1\\/thread\\/2\' target=\'_blank\'>\\u6211\\u4e0d\\u60f3\\u88c5\\u903c\\uff0c\\u6211\\u53ea\\u60f3\\u663e\\u6446<\\/a>\\uff0c\\u8bf7\\u53ca\\u65f6\\u56de\\u7b54\\u3002\"}', '1411292469', '0'), ('10', '1', 'default', '{\"message\":\"\\u3010\\u8bd5\\u5377\\u5df2\\u5b8c\\u6210\\u3011 <a href=\'http:\\/\\/localhost\\/edusoho\\/web\\/user\\/1\' target=\'_blank\'>\\u718a\\u5148\\u751f<\\/a> \\u521a\\u521a\\u5b8c\\u6210\\u4e86 \\u88c5\\u903c\\u8003\\u8bd5 \\uff0c<a href=\'http:\\/\\/localhost\\/edusoho\\/web\\/test\\/2\\/teacher\\/check\' target=\'_blank\'>\\u8bf7\\u70b9\\u51fb\\u6279\\u9605<\\/a>\"}', '1419056654', '0'), ('11', '2', 'default', '{\"message\":\"\\u60a8\\u7684\\u4e2a\\u4eba\\u5b9e\\u540d\\u8ba4\\u8bc1\\uff0c\\u5ba1\\u6838\\u672a\\u901a\\u8fc7\\uff01(\\u7ba1\\u7406\\u5458\\u64a4\\u9500)\"}', '1419140336', '0'), ('12', '1', 'default', '{\"message\":\"\\u60a8\\u7684\\u4e2a\\u4eba\\u5b9e\\u540d\\u8ba4\\u8bc1\\uff0c\\u5ba1\\u6838\\u672a\\u901a\\u8fc7\\uff01(\\u7ba1\\u7406\\u5458\\u64a4\\u9500)\"}', '1419140338', '0');
COMMIT;

-- ----------------------------
--  Table structure for `order_log`
-- ----------------------------
DROP TABLE IF EXISTS `order_log`;
CREATE TABLE `order_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '订单日志ID',
  `orderId` int(10) unsigned NOT NULL COMMENT '订单ID',
  `type` varchar(32) NOT NULL COMMENT '订单日志类型',
  `message` text COMMENT '订单日志内容',
  `data` text COMMENT '订单日志数据',
  `userId` int(10) unsigned NOT NULL COMMENT '订单操作人',
  `ip` varchar(255) NOT NULL COMMENT '订单操作IP',
  `createdTime` int(10) unsigned NOT NULL COMMENT '订单日志记录时间',
  PRIMARY KEY (`id`),
  KEY `orderId` (`orderId`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `order_log`
-- ----------------------------
BEGIN;
INSERT INTO `order_log` VALUES ('1', '1', 'created', '创建订单', '[]', '1', '::1', '1411095682'), ('2', '1', 'pay_success', '付款成功', '{\"sn\":\"C2014091911012243637\",\"status\":\"success\",\"amount\":\"0.00\",\"paidTime\":1411095682}', '1', '::1', '1411095682'), ('3', '2', 'created', '创建订单', '[]', '1', '::1', '1411095692'), ('4', '2', 'pay_success', '付款成功', '{\"sn\":\"C2014091911013239601\",\"status\":\"success\",\"amount\":\"0.00\",\"paidTime\":1411095692}', '1', '::1', '1411095692'), ('5', '3', 'created', '创建订单', '[]', '4', '::1', '1411105933'), ('6', '3', 'pay_success', '付款成功', '{\"sn\":\"C2014091913521350072\",\"status\":\"success\",\"amount\":\"0.00\",\"paidTime\":1411105933}', '4', '::1', '1411105933'), ('7', '4', 'created', '创建订单', '[]', '2', '::1', '1411208559'), ('8', '4', 'pay_success', '付款成功', '{\"sn\":\"C2014092018223933161\",\"status\":\"success\",\"amount\":\"0.00\",\"paidTime\":1411208559}', '2', '::1', '1411208559'), ('9', '5', 'created', '创建订单', '[]', '4', '::1', '1427420697'), ('10', '5', 'pay_success', '付款成功', '{\"sn\":\"C2015032709445750447\",\"status\":\"success\",\"amount\":\"0.00\",\"paidTime\":1427420697}', '4', '::1', '1427420697');
COMMIT;

-- ----------------------------
--  Table structure for `order_refund`
-- ----------------------------
DROP TABLE IF EXISTS `order_refund`;
CREATE TABLE `order_refund` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '订单退款记录ID',
  `orderId` int(10) unsigned NOT NULL COMMENT '退款订单ID',
  `userId` int(10) unsigned NOT NULL COMMENT '退款人ID',
  `targetType` varchar(64) NOT NULL DEFAULT '' COMMENT '订单退款记录所属对象类型',
  `targetId` int(10) unsigned NOT NULL COMMENT '订单退款记录所属对象ID',
  `status` enum('created','success','failed','cancelled') NOT NULL DEFAULT 'created' COMMENT '退款状态',
  `expectedAmount` float(10,2) unsigned DEFAULT '0.00' COMMENT '期望退款的金额，NULL代表未知，0代表不需要退款',
  `actualAmount` float(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '实际退款金额，0代表无退款',
  `reasonType` varchar(64) NOT NULL DEFAULT '' COMMENT '退款理由类型',
  `reasonNote` varchar(1024) NOT NULL DEFAULT '' COMMENT '退款理由',
  `updatedTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '订单退款记录最后更新时间',
  `createdTime` int(10) unsigned NOT NULL COMMENT '订单退款记录创建时间',
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `orders`
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '订单ID',
  `sn` varchar(32) NOT NULL COMMENT '订单编号',
  `status` enum('created','paid','refunding','refunded','cancelled') NOT NULL COMMENT '订单状态',
  `title` varchar(255) NOT NULL COMMENT '订单标题',
  `targetType` varchar(64) NOT NULL DEFAULT '' COMMENT '订单所属对象类型',
  `targetId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '订单所属对象ID',
  `amount` float(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '订单实付金额',
  `isGift` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否为赠送礼物',
  `giftTo` varchar(64) NOT NULL DEFAULT '' COMMENT '赠送给用户ID',
  `refundId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后一次退款操作记录的ID',
  `userId` int(10) unsigned NOT NULL COMMENT '订单创建人',
  `coupon` varchar(255) NOT NULL DEFAULT '' COMMENT '优惠码',
  `couponDiscount` float(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '优惠码扣减金额',
  `payment` enum('none','alipay','tenpay') NOT NULL DEFAULT 'none' COMMENT '订单支付方式',
  `bank` varchar(32) NOT NULL DEFAULT '' COMMENT '银行编号',
  `paidTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '支付时间',
  `note` varchar(255) NOT NULL DEFAULT '' COMMENT '备注',
  `data` text COMMENT '订单业务数据',
  `createdTime` int(10) unsigned NOT NULL COMMENT '订单创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sn` (`sn`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `orders`
-- ----------------------------
BEGIN;
INSERT INTO `orders` VALUES ('1', 'C2014091911012243637', 'paid', '购买课程《如何成为屌丝》(管理员添加)', 'course', '2', '0.00', '0', '', '0', '1', '', '0.00', 'none', '', '1411095682', '', null, '1411095682'), ('2', 'C2014091911013239601', 'paid', '购买课程《如何成为屌丝》(管理员添加)', 'course', '2', '0.00', '0', '', '0', '3', '', '0.00', 'none', '', '1411095692', '', null, '1411095692'), ('3', 'C2014091913521350072', 'paid', '购买课程《如何成为屌丝》', 'course', '2', '0.00', '0', '', '0', '4', '', '0.00', 'none', '', '1411105933', '', null, '1411105933'), ('4', 'C2014092018223933161', 'paid', '购买课程《装逼培训》', 'course', '1', '0.00', '0', '', '0', '2', '', '0.00', 'none', '', '1411208559', '', null, '1411208559'), ('5', 'C2015032709445750447', 'paid', '购买课程《如何成为一名合格的程序员》', 'course', '1', '0.00', '0', '', '0', '4', '', '0.00', 'none', '', '1427420697', '', null, '1427420697');
COMMIT;

-- ----------------------------
--  Table structure for `question`
-- ----------------------------
DROP TABLE IF EXISTS `question`;
CREATE TABLE `question` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '题目ID',
  `type` varchar(64) NOT NULL DEFAULT '' COMMENT '题目类型',
  `stem` text COMMENT '题干',
  `score` float(10,1) unsigned NOT NULL DEFAULT '0.0' COMMENT '分数',
  `answer` text COMMENT '参考答案',
  `analysis` text COMMENT '解析',
  `metas` text COMMENT '题目元信息',
  `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '类别',
  `difficulty` varchar(64) NOT NULL DEFAULT 'normal' COMMENT '难度',
  `target` varchar(255) NOT NULL DEFAULT '' COMMENT '从属于',
  `parentId` int(10) unsigned DEFAULT '0' COMMENT '材料父ID',
  `subCount` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '子题数量',
  `finishedTimes` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '完成次数',
  `passedTimes` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '成功次数',
  `userId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
  `updatedTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `createdTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='问题表';

-- ----------------------------
--  Records of `question`
-- ----------------------------
BEGIN;
INSERT INTO `question` VALUES ('1', 'single_choice', '请问一下哪种情况算是装逼？', '2.0', '[\"0\"]', '', '{\"choices\":[\"a\\u3001\\u88c5\\u903c\\u884c\\u4e3a1\",\"a\\u3001\\u88c5\\u903c\\u884c\\u4e3a2\",\"a\\u3001\\u88c5\\u903c\\u884c\\u4e3a3\",\"a\\u3001\\u88c5\\u903c\\u884c\\u4e3a4\"]}', '1', 'normal', 'course-1', '0', '0', '0', '0', '1', '1411207593', '1411207409'), ('2', 'single_choice', '请问你为什么要装逼？', '2.0', '[\"0\"]', '', '{\"choices\":[\"a\\u3001\\u559c\\u6b22\\u88c5\\u903c\",\"b\\u3001\\u5fc5\\u987b\\u88c5\\u903c\",\"c\\u3001\\u5f62\\u52bf\\u6240\\u8feb\",\"d\\u3001\\u5c31\\u8981\\u88c5\\u903c\"]}', '1', 'normal', 'course-1', '0', '0', '0', '0', '1', '1411207585', '1411207453'), ('3', 'essay', '你觉得装逼成功爽不爽？请说明。', '2.0', '[\"\\u8fd8\\u8981\\u8f93\\u5165\\u7b54\\u6848\\uff0c\\u4e3a\\u4f55\"]', '', '[]', '1', 'normal', 'course-1', '0', '0', '1', '0', '1', '1411207569', '1411207569'), ('4', 'determine', '我觉得黄晓明很帅气', '2.0', '[\"1\"]', '', '[]', '0', 'normal', 'course-1', '0', '0', '0', '0', '1', '1427420512', '1427420512'), ('5', 'essay', '你觉得天天向上这个综艺节目怎么样？', '2.0', '[\"\\u6211\\u89c9\\u5f97\\u8fd9\\u8282\\u76ee\\u592a\\u641e\\u7b11\\u4e86\"]', '', '[]', '0', 'normal', 'course-1', '0', '0', '0', '0', '1', '1427420543', '1427420543');
COMMIT;

-- ----------------------------
--  Table structure for `question_category`
-- ----------------------------
DROP TABLE IF EXISTS `question_category`;
CREATE TABLE `question_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '题目类别ID',
  `name` varchar(255) NOT NULL COMMENT '类别名称',
  `target` varchar(255) NOT NULL DEFAULT '' COMMENT '从属于',
  `userId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作用户',
  `updatedTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `createdTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `seq` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序序号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='题库类别表';

-- ----------------------------
--  Records of `question_category`
-- ----------------------------
BEGIN;
INSERT INTO `question_category` VALUES ('1', '装逼题库', 'course-1', '1', '1411207465', '1411207465', '1'), ('2', '新题库', 'course-3', '2', '1411297917', '1411297917', '1');
COMMIT;

-- ----------------------------
--  Table structure for `question_favorite`
-- ----------------------------
DROP TABLE IF EXISTS `question_favorite`;
CREATE TABLE `question_favorite` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '题目收藏ID',
  `questionId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '被收藏的题目ID',
  `target` varchar(255) NOT NULL DEFAULT '' COMMENT '题目所属对象',
  `userId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '收藏人ID',
  `createdTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '收藏时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `session2`
-- ----------------------------
DROP TABLE IF EXISTS `session2`;
CREATE TABLE `session2` (
  `session_id` varchar(255) NOT NULL,
  `session_value` text NOT NULL,
  `session_time` int(11) NOT NULL,
  `user_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `session2`
-- ----------------------------
BEGIN;
INSERT INTO `session2` VALUES ('4b0129ca1a48ccaa2fccd2e202acbe93', 'X3NmMl9hdHRyaWJ1dGVzfGE6MDp7fV9zZjJfZmxhc2hlc3xhOjA6e31fc2YyX21ldGF8YTozOntzOjE6InUiO2k6MTQyNzQyMTk2MDtzOjE6ImMiO2k6MTQyNzQyMTk1ODtzOjE6ImwiO3M6MToiMCI7fQ==', '1427421960', '0'), ('62646b5ce475a576aee62f2dd56c4132', 'X3NmMl9hdHRyaWJ1dGVzfGE6MDp7fV9zZjJfZmxhc2hlc3xhOjA6e31fc2YyX21ldGF8YTozOntzOjE6InUiO2k6MTQyNzQyMDY0NTtzOjE6ImMiO2k6MTQyNzQyMDY0NDtzOjE6ImwiO3M6MToiMCI7fQ==', '1427420645', '0'), ('62fc293a1d299b7543ddd7de374e9be5', 'X3NmMl9hdHRyaWJ1dGVzfGE6MTp7czoxNDoiX3NlY3VyaXR5X21haW4iO3M6MTI1ODoiQzo3NDoiU3ltZm9ueVxDb21wb25lbnRcU2VjdXJpdHlcQ29yZVxBdXRoZW50aWNhdGlvblxUb2tlblxVc2VybmFtZVBhc3N3b3JkVG9rZW4iOjExNjk6e2E6Mzp7aTowO047aToxO3M6NDoibWFpbiI7aToyO3M6MTEyODoiYTo0OntpOjA7TzozMToiVG9weGlhXFNlcnZpY2VcVXNlclxDdXJyZW50VXNlciI6MTp7czo3OiIAKgBkYXRhIjthOjMwOntzOjI6ImlkIjtzOjE6IjQiO3M6NToiZW1haWwiO3M6MjI6ImRlbmdsaW5nZmVuZ0BzaHNuYy5jb20iO3M6ODoicGFzc3dvcmQiO3M6NDQ6IkhEZURKWWd4UlZhSlgyWXMwMlZaNGIwSktOOThUNHlZajFrVU0wSW9hblk9IjtzOjQ6InNhbHQiO3M6MzE6IjF1Z2FrYzQzenZrMHM4c3drbzg4azQwc2tjczRnbzgiO3M6MzoidXJpIjtzOjA6IiI7czo4OiJuaWNrbmFtZSI7czo2OiLlh4zls7AiO3M6NToidGl0bGUiO3M6MDoiIjtzOjQ6InRhZ3MiO3M6MDoiIjtzOjQ6InR5cGUiO3M6NzoiZGVmYXVsdCI7czo1OiJwb2ludCI7czoxOiIwIjtzOjQ6ImNvaW4iO3M6MToiMCI7czoxMToic21hbGxBdmF0YXIiO3M6MDoiIjtzOjEyOiJtZWRpdW1BdmF0YXIiO3M6MDoiIjtzOjExOiJsYXJnZUF2YXRhciI7czowOiIiO3M6MTM6ImVtYWlsVmVyaWZpZWQiO3M6MToiMCI7czo1OiJzZXR1cCI7czoxOiIxIjtzOjU6InJvbGVzIjthOjE6e2k6MDtzOjk6IlJPTEVfVVNFUiI7fXM6ODoicHJvbW90ZWQiO3M6MToiMCI7czoxMjoicHJvbW90ZWRUaW1lIjtzOjE6IjAiO3M6NjoibG9ja2VkIjtzOjE6IjAiO3M6OToibG9naW5UaW1lIjtzOjEwOiIxNDI3NDIxOTY3IjtzOjc6ImxvZ2luSXAiO3M6MzoiOjoxIjtzOjE0OiJsb2dpblNlc3Npb25JZCI7czozMjoiNjJmYzI5M2ExZDI5OWI3NTQzZGRkN2RlMzc0ZTliZTUiO3M6MTI6ImFwcHJvdmFsVGltZSI7czoxOiIwIjtzOjE0OiJhcHByb3ZhbFN0YXR1cyI7czo5OiJ1bmFwcHJvdmUiO3M6MTM6Im5ld01lc3NhZ2VOdW0iO3M6MToiMSI7czoxODoibmV3Tm90aWZpY2F0aW9uTnVtIjtzOjE6IjAiO3M6OToiY3JlYXRlZElwIjtzOjM6Ijo6MSI7czoxMToiY3JlYXRlZFRpbWUiO3M6MTA6IjE0MTExMDU5MDgiO3M6OToiY3VycmVudElwIjtzOjM6Ijo6MSI7fX1pOjE7YjoxO2k6MjthOjE6e2k6MDtPOjQxOiJTeW1mb255XENvbXBvbmVudFxTZWN1cml0eVxDb3JlXFJvbGVcUm9sZSI6MTp7czo0NzoiAFN5bWZvbnlcQ29tcG9uZW50XFNlY3VyaXR5XENvcmVcUm9sZVxSb2xlAHJvbGUiO3M6OToiUk9MRV9VU0VSIjt9fWk6MzthOjA6e319Ijt9fSI7fV9zZjJfZmxhc2hlc3xhOjA6e31fc2YyX21ldGF8YTozOntzOjE6InUiO2k6MTQyNzQyMjAyMTtzOjE6ImMiO2k6MTQyNzQyMTk1ODtzOjE6ImwiO3M6MToiMCI7fQ==', '1427422021', '4'), ('74d75c6044995267dcd9db1a5da31c27', 'X3NmMl9hdHRyaWJ1dGVzfGE6MTp7czoxNDoiX3NlY3VyaXR5X21haW4iO3M6MTc2OToiQzo2ODoiU3ltZm9ueVxDb21wb25lbnRcU2VjdXJpdHlcQ29yZVxBdXRoZW50aWNhdGlvblxUb2tlblxSZW1lbWJlck1lVG9rZW4iOjE2ODY6e2E6Mzp7aTowO3M6MzE6IjJudW12d2U2cnZhY2s0a2dvMGswMGdjb3NrMDhja2ciO2k6MTtzOjQ6Im1haW4iO2k6MjtzOjE2MDg6ImE6NDp7aTowO086MzE6IlRvcHhpYVxTZXJ2aWNlXFVzZXJcQ3VycmVudFVzZXIiOjE6e3M6NzoiACoAZGF0YSI7YTozMDp7czoyOiJpZCI7czoxOiIxIjtzOjU6ImVtYWlsIjtzOjIwOiJ0b25nemhlbmtlQGdtYWlsLmNvbSI7czo4OiJwYXNzd29yZCI7czo0NDoiRWUyT0VhQlhLdVFNR2c4RTJhNjExMVFEQUdxQnlUWHFzS2JBQXdnS3lNST0iO3M6NDoic2FsdCI7czozMToibHZpaHE4anM2bGNrb2NnMHdjczg4d2N3ODg4bzAwayI7czozOiJ1cmkiO3M6MDoiIjtzOjg6Im5pY2tuYW1lIjtzOjk6IueGiuWFiOeUnyI7czo1OiJ0aXRsZSI7czo0OiJ0ZXN0IjtzOjQ6InRhZ3MiO3M6MDoiIjtzOjQ6InR5cGUiO3M6NzoiZGVmYXVsdCI7czo1OiJwb2ludCI7czoxOiIwIjtzOjQ6ImNvaW4iO3M6MToiMCI7czoxMToic21hbGxBdmF0YXIiO3M6NDc6InB1YmxpYzovL3VzZXIvMjAxNC8wOS0xOC8yMzE4MjBjNTU5YmUxNjk3MjIuanBnIjtzOjEyOiJtZWRpdW1BdmF0YXIiO3M6NDc6InB1YmxpYzovL3VzZXIvMjAxNC8wOS0xOC8yMzE4MjBjNTQ4NDkyMjU4NDYuanBnIjtzOjExOiJsYXJnZUF2YXRhciI7czo0NzoicHVibGljOi8vdXNlci8yMDE0LzA5LTE4LzIzMTgyMGM1MGQ0YzkwMDA4OS5qcGciO3M6MTM6ImVtYWlsVmVyaWZpZWQiO3M6MToiMCI7czo1OiJzZXR1cCI7czoxOiIxIjtzOjU6InJvbGVzIjthOjM6e2k6MDtzOjk6IlJPTEVfVVNFUiI7aToxO3M6MTI6IlJPTEVfVEVBQ0hFUiI7aToyO3M6MTY6IlJPTEVfU1VQRVJfQURNSU4iO31zOjg6InByb21vdGVkIjtzOjE6IjAiO3M6MTI6InByb21vdGVkVGltZSI7czoxOiIwIjtzOjY6ImxvY2tlZCI7czoxOiIwIjtzOjk6ImxvZ2luVGltZSI7czoxMDoiMTQyNzQzNjY3OSI7czo3OiJsb2dpbklwIjtzOjM6Ijo6MSI7czoxNDoibG9naW5TZXNzaW9uSWQiO3M6MzI6Ijc0ZDc1YzYwNDQ5OTUyNjdkY2Q5ZGIxYTVkYTMxYzI3IjtzOjEyOiJhcHByb3ZhbFRpbWUiO3M6MTA6IjE0MTkxNDAzMzgiO3M6MTQ6ImFwcHJvdmFsU3RhdHVzIjtzOjEyOiJhcHByb3ZlX2ZhaWwiO3M6MTM6Im5ld01lc3NhZ2VOdW0iO3M6MToiMCI7czoxODoibmV3Tm90aWZpY2F0aW9uTnVtIjtzOjE6IjAiO3M6OToiY3JlYXRlZElwIjtzOjA6IiI7czoxMToiY3JlYXRlZFRpbWUiO3M6MTA6IjE0MTA5MjA5MDAiO3M6OToiY3VycmVudElwIjtzOjM6Ijo6MSI7fX1pOjE7YjoxO2k6MjthOjM6e2k6MDtPOjQxOiJTeW1mb255XENvbXBvbmVudFxTZWN1cml0eVxDb3JlXFJvbGVcUm9sZSI6MTp7czo0NzoiAFN5bWZvbnlcQ29tcG9uZW50XFNlY3VyaXR5XENvcmVcUm9sZVxSb2xlAHJvbGUiO3M6OToiUk9MRV9VU0VSIjt9aToxO086NDE6IlN5bWZvbnlcQ29tcG9uZW50XFNlY3VyaXR5XENvcmVcUm9sZVxSb2xlIjoxOntzOjQ3OiIAU3ltZm9ueVxDb21wb25lbnRcU2VjdXJpdHlcQ29yZVxSb2xlXFJvbGUAcm9sZSI7czoxMjoiUk9MRV9URUFDSEVSIjt9aToyO086NDE6IlN5bWZvbnlcQ29tcG9uZW50XFNlY3VyaXR5XENvcmVcUm9sZVxSb2xlIjoxOntzOjQ3OiIAU3ltZm9ueVxDb21wb25lbnRcU2VjdXJpdHlcQ29yZVxSb2xlXFJvbGUAcm9sZSI7czoxNjoiUk9MRV9TVVBFUl9BRE1JTiI7fX1pOjM7YTowOnt9fSI7fX0iO31fc2YyX2ZsYXNoZXN8YTowOnt9X3NmMl9tZXRhfGE6Mzp7czoxOiJ1IjtpOjE0Mjc0MzcyOTE7czoxOiJjIjtpOjE0Mjc0MzY2Nzk7czoxOiJsIjtzOjE6IjAiO30=', '1427437291', '1'), ('8a53ada43b77dee2aa5100bb58b849c2', 'X3NmMl9hdHRyaWJ1dGVzfGE6MDp7fV9zZjJfZmxhc2hlc3xhOjA6e31fc2YyX21ldGF8YTozOntzOjE6InUiO2k6MTQyNzQyMDc0ODtzOjE6ImMiO2k6MTQyNzQyMDc0ODtzOjE6ImwiO3M6MToiMCI7fQ==', '1427420749', '0'), ('a3cfdb2bd64ca0ff72fe67c2d27f9f49', 'X3NmMl9hdHRyaWJ1dGVzfGE6MDp7fV9zZjJfZmxhc2hlc3xhOjA6e31fc2YyX21ldGF8YTozOntzOjE6InUiO2k6MTQyNzQyMDY3NDtzOjE6ImMiO2k6MTQyNzQyMDY3NDtzOjE6ImwiO3M6MToiMCI7fQ==', '1427420674', '0'), ('bcf7d22970fdedc2ef3d8b9488ca462a', 'X3NmMl9hdHRyaWJ1dGVzfGE6Mzp7czoyMzoiX3NlY3VyaXR5Lmxhc3RfdXNlcm5hbWUiO3M6Njoi5YeM5bOwIjtzOjEyOiJfdGFyZ2V0X3BhdGgiO3M6NDQ6Imh0dHA6Ly9sb2NhbGhvc3Q6OTk5OS9lZHVzb2hvL3dlYi9hZG1pbi91c2VyIjtzOjIwOiJfc2VjdXJpdHkubGFzdF9lcnJvciI7Qzo2NToiU3ltZm9ueVxDb21wb25lbnRcU2VjdXJpdHlcQ29yZVxFeGNlcHRpb25cQmFkQ3JlZGVudGlhbHNFeGNlcHRpb24iOjM5Nzp7YTo1OntpOjA7Qzo3NDoiU3ltZm9ueVxDb21wb25lbnRcU2VjdXJpdHlcQ29yZVxBdXRoZW50aWNhdGlvblxUb2tlblxVc2VybmFtZVBhc3N3b3JkVG9rZW4iOjEwNDp7YTozOntpOjA7czo5OiJ3b2Fpd29qaWEiO2k6MTtzOjQ6Im1haW4iO2k6MjtzOjUxOiJhOjQ6e2k6MDtzOjY6IuWHjOWzsCI7aToxO2I6MDtpOjI7YTowOnt9aTozO2E6MDp7fX0iO319aToxO2k6MDtpOjI7czoxNToiQmFkIGNyZWRlbnRpYWxzIjtpOjM7czoxMzg6Ii9Vc2Vycy9tZS9odGRvY3MvZWR1c29oby92ZW5kb3Ivc3ltZm9ueS9zeW1mb255L3NyYy9TeW1mb255L0NvbXBvbmVudC9TZWN1cml0eS9Db3JlL0F1dGhlbnRpY2F0aW9uL1Byb3ZpZGVyL1VzZXJBdXRoZW50aWNhdGlvblByb3ZpZGVyLnBocCI7aTo0O2k6OTA7fX19X3NmMl9mbGFzaGVzfGE6MDp7fV9zZjJfbWV0YXxhOjM6e3M6MToidSI7aToxNDI3NDIwNjA2O3M6MToiYyI7aToxNDI3NDIwNjAwO3M6MToibCI7czoxOiIwIjt9', '1427420606', '0');
COMMIT;

-- ----------------------------
--  Table structure for `setting`
-- ----------------------------
DROP TABLE IF EXISTS `setting`;
CREATE TABLE `setting` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '系统设置ID',
  `name` varchar(64) NOT NULL DEFAULT '' COMMENT '系统设置名',
  `value` longblob COMMENT '系统设置值',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `setting`
-- ----------------------------
BEGIN;
INSERT INTO `setting` VALUES ('2', 'auth', 0x613a383a7b733a31333a2272656769737465725f6d6f6465223b733a363a226f70656e6564223b733a32323a22656d61696c5f61637469766174696f6e5f7469746c65223b733a33333a22e8afb7e6bf80e6b4bbe682a8e79a847b7b736974656e616d657d7de5b890e58fb7223b733a32313a22656d61696c5f61637469766174696f6e5f626f6479223b733a3336363a2248692c207b7b6e69636b6e616d657d7d0a0ae6aca2e8bf8ee58aa0e585a57b7b736974656e616d657d7d210a0ae8afb7e782b9e587bbe4b88be99da2e79a84e993bee68ea5e5ae8ce68890e6b3a8e5868cefbc9a0a0a7b7b76657269667975726c7d7d0a0ae5a682e69e9ce4bba5e4b88ae993bee68ea5e697a0e6b395e782b9e587bbefbc8ce8afb7e5b086e4b88ae99da2e79a84e59cb0e59d80e5a48de588b6e588b0e4bda0e79a84e6b58fe8a788e599a828e5a682494529e79a84e59cb0e59d80e6a08fe4b8ade68993e5bc80efbc8ce8afa5e993bee68ea5e59cb0e59d803234e5b08fe697b6e58685e68993e5bc80e69c89e69588e380820a0ae6849fe8b0a2e5afb97b7b736974656e616d657d7de79a84e694afe68c81efbc810a0a7b7b736974656e616d657d7d207b7b7369746575726c7d7d0a0a28e8bf99e698afe4b880e5b081e887aae58aa8e4baa7e7949fe79a84656d61696cefbc8ce8afb7e58bbfe59b9ee5a48de3808229223b733a31353a2277656c636f6d655f656e61626c6564223b733a363a226f70656e6564223b733a31343a2277656c636f6d655f73656e646572223b733a393a22e7868ae58588e7949f223b733a31353a2277656c636f6d655f6d6574686f6473223b613a303a7b7d733a31333a2277656c636f6d655f7469746c65223b733a32343a22e6aca2e8bf8ee58aa0e585a57b7b736974656e616d657d7d223b733a31323a2277656c636f6d655f626f6479223b733a3133383a22e682a8e5a5bd7b7b6e69636b6e616d657d7defbc8ce68891e698af7b7b736974656e616d657d7de79a84e7aea1e79086e59198efbc8ce6aca2e8bf8ee58aa0e585a57b7b736974656e616d657d7defbc8ce7a59de682a8e5ada6e4b9a0e68489e5bfabe38082e5a682e69c89e997aee9a298efbc8ce99a8fe697b6e4b88ee68891e88194e7b3bbe38082223b7d), ('3', 'mailer', 0x613a373a7b733a373a22656e61626c6564223b693a303b733a343a22686f7374223b733a31363a22736d74702e6578616d706c652e636f6d223b733a343a22706f7274223b733a323a223235223b733a383a22757365726e616d65223b733a31363a2275736572406578616d706c652e636f6d223b733a383a2270617373776f7264223b733a303a22223b733a343a2266726f6d223b733a31363a2275736572406578616d706c652e636f6d223b733a343a226e616d65223b733a31393a22456475536f686fe7bd91e7bb9ce8afbee5a082223b7d), ('4', 'payment', 0x613a353a7b733a373a22656e61626c6564223b693a303b733a31323a2262616e6b5f67617465776179223b733a343a226e6f6e65223b733a31343a22616c697061795f656e61626c6564223b693a303b733a31303a22616c697061795f6b6579223b733a303a22223b733a31333a22616c697061795f736563726574223b733a303a22223b7d), ('5', 'storage', 0x613a343a7b733a31313a2275706c6f61645f6d6f6465223b733a353a226c6f63616c223b733a31363a22636c6f75645f6163636573735f6b6579223b733a303a22223b733a31323a22636c6f75645f6275636b6574223b733a303a22223b733a31363a22636c6f75645f7365637265745f6b6579223b733a303a22223b7d), ('7', 'refund', 0x613a343a7b733a31333a226d6178526566756e6444617973223b693a31303b733a31373a226170706c794e6f74696669636174696f6e223b733a3131383a22e682a8e5a5bdefbc8ce682a8e98080e6acbee79a84e8afbee7a88be4b8ba7b7b636f757273657d7defbc8ce7aea1e79086e59198e5b7b2e694b6e588b0e682a8e79a84e98080e6acbee794b3e8afb7efbc8ce8afb7e88090e5bf83e7ad89e5be85e98080e6acbee5aea1e6a0b8e7bb93e69e9ce38082223b733a31393a22737563636573734e6f74696669636174696f6e223b733a38373a22e682a8e5a5bdefbc8ce682a8e794b3e8afb7e98080e6acbee8afbee7a88b7b7b636f757273657d7d20e5aea1e6a0b8e9809ae8bf87efbc8ce5b086e4b8bae682a8e98080e6acbe7b7b616d6f756e747d7de58583e38082223b733a31383a226661696c65644e6f74696669636174696f6e223b733a39383a22e682a8e5a5bdefbc8ce682a8e794b3e8afb7e98080e6acbee8afbee7a88b7b7b636f757273657d7d20e5aea1e6a0b8e69caae9809ae8bf87efbc8ce8afb7e4b88ee7aea1e79086e59198e5868de58d8fe59586e8a7a3e586b3e7baa0e7bab7e38082223b7d), ('19', 'article', 0x613a323a7b733a343a226e616d65223b733a31323a22e8b584e8aeafe9a291e98193223b733a383a22706167654e756d73223b733a313a2235223b7d), ('28', 'theme', 0x613a373a7b733a343a226e616d65223b733a31353a22e9bb98e8aea4e4b8bbe9a298284229223b733a363a22617574686f72223b733a31333a22456475536f686fe5ae98e696b9223b733a373a2276657273696f6e223b733a333a22312e30223b733a31353a2273757070726f745f76657273696f6e223b733a343a22312e302b223b733a343a2264617465223b733a31303a22323031332d31312d3037223b733a353a227468756d62223b733a31333a22696d672f7468656d652e6a7067223b733a333a22757269223b733a393a2264656661756c742d62223b7d), ('54', '_app_cop', 0x693a313b), ('56', 'site', 0x613a31333a7b733a343a226e616d65223b733a32333a225669676f72e59ca8e7babfe59fb9e8aeade5b9b3e58fb0223b733a363a22736c6f67616e223b733a31383a22e6b1bde8bda6e592a8e8afa2e4b893e5aeb6223b733a333a2275726c223b733a303a22223b733a343a226c6f676f223b733a303a22223b733a373a2266617669636f6e223b733a303a22223b733a31323a2273656f5f6b6579776f726473223b733a363a22e58a9be6b4bb223b733a31353a2273656f5f6465736372697074696f6e223b733a33363a22e4b88ae6b5b7e58a9be6b4bbe4bfa1e681afe68a80e69cafe69c89e99990e585ace58fb8223b733a31323a226d61737465725f656d61696c223b733a31383a226a6176615f7261696e79403132362e636f6d223b733a393a22636f70797269676874223b733a393a22e7868ae58588e7949f223b733a333a22696370223b733a303a22223b733a393a22616e616c7974696373223b733a303a22223b733a363a22737461747573223b733a343a226f70656e223b733a31313a22636c6f7365645f6e6f7465223b733a303a22223b7d), ('69', 'course', 0x613a31333a7b733a32333a2277656c636f6d655f6d6573736167655f656e61626c6564223b733a313a2231223b733a32303a2277656c636f6d655f6d6573736167655f626f6479223b733a34313a227b7b6e69636b6e616d657d7d2ce6aca2e8bf8ee58aa0e585a5e8afbee7a88b7b7b636f757273657d7d223b733a31373a226275795f66696c6c5f75736572696e666f223b733a313a2230223b733a32323a2275736572696e666f4669656c644e616d654172726179223b613a393a7b693a303b733a383a22747275656e616d65223b693a313b733a363a226d6f62696c65223b693a323b733a323a227171223b693a333b733a373a22636f6d70616e79223b693a343b733a333a226a6f62223b693a353b733a363a2267656e646572223b693a363b733a363a22696463617264223b693a373b733a353a22776569626f223b693a383b733a363a2277656978696e223b7d733a32303a22746561636865725f6d6f646966795f7072696365223b733a313a2231223b733a32323a22746561636865725f6d616e6167655f73747564656e74223b733a313a2230223b733a32323a22746561636865725f6578706f72745f73747564656e74223b733a313a2230223b733a32323a2273747564656e745f646f776e6c6f61645f6d65646961223b733a313a2230223b733a31343a2272656c61746564436f7572736573223b733a313a2230223b733a32313a22616c6c6f77416e6f6e796d6f757350726576696577223b733a313a2231223b733a31393a226c6976655f636f757273655f656e61626c6564223b733a313a2230223b733a32313a226c6976655f73747564656e745f6361706163697479223b693a303b733a31343a2275736572696e666f4669656c6473223b613a303a7b7d7d), ('70', '_app_last_check', 0x693a313432373432303336363b);
COMMIT;

-- ----------------------------
--  Table structure for `tag`
-- ----------------------------
DROP TABLE IF EXISTS `tag`;
CREATE TABLE `tag` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '标签ID',
  `name` varchar(64) NOT NULL COMMENT '标签名称',
  `createdTime` int(10) unsigned NOT NULL COMMENT '标签创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `testpaper`
-- ----------------------------
DROP TABLE IF EXISTS `testpaper`;
CREATE TABLE `testpaper` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '试卷ID',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '试卷名称',
  `description` text COMMENT '试卷说明',
  `limitedTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '限时(单位：秒)',
  `pattern` varchar(255) NOT NULL DEFAULT '' COMMENT '试卷生成/显示模式',
  `target` varchar(255) NOT NULL DEFAULT '' COMMENT '试卷所属对象',
  `status` varchar(32) NOT NULL DEFAULT 'draft' COMMENT '试卷状态：draft,open,closed',
  `score` float(10,1) unsigned NOT NULL DEFAULT '0.0' COMMENT '总分',
  `passedScore` float(10,1) unsigned NOT NULL DEFAULT '0.0' COMMENT '通过考试的分数线',
  `itemCount` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '题目数量',
  `createdUserId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建人',
  `createdTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatedUserId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改人',
  `updatedTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  `metas` text COMMENT '题型排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `testpaper`
-- ----------------------------
BEGIN;
INSERT INTO `testpaper` VALUES ('1', '装逼考试', '60分你就装逼成功', '30', 'QuestionType', 'course-1', 'open', '100.0', '0.0', '3', '1', '1411208276', '1', '1411208276', '{\"question_type_seq\":[\"single_choice\",\"essay\"],\"missScore\":{\"choice\":\"0\",\"uncertain_choice\":\"0\"}}'), ('2', '测评试卷', '在线测评试卷', '30', 'QuestionType', 'course-1', 'draft', '100.0', '0.0', '5', '1', '1427437270', '1', '1427437270', '{\"question_type_seq\":[\"single_choice\",\"determine\",\"essay\"],\"missScore\":{\"choice\":\"0\",\"uncertain_choice\":\"0\"}}');
COMMIT;

-- ----------------------------
--  Table structure for `testpaper_item`
-- ----------------------------
DROP TABLE IF EXISTS `testpaper_item`;
CREATE TABLE `testpaper_item` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '试卷条目ID',
  `testId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所属试卷',
  `seq` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '题目顺序',
  `questionId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '题目ID',
  `questionType` varchar(64) NOT NULL DEFAULT '' COMMENT '题目类别',
  `parentId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父题ID',
  `score` float(10,1) unsigned NOT NULL DEFAULT '0.0' COMMENT '分值',
  `missScore` float(10,1) unsigned NOT NULL DEFAULT '0.0' COMMENT '漏选得分',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `testpaper_item`
-- ----------------------------
BEGIN;
INSERT INTO `testpaper_item` VALUES ('4', '1', '1', '2', 'single_choice', '0', '30.0', '0.0'), ('5', '1', '2', '1', 'single_choice', '0', '30.0', '0.0'), ('6', '1', '3', '3', 'essay', '0', '40.0', '0.0'), ('7', '2', '1', '2', 'single_choice', '0', '20.0', '0.0'), ('8', '2', '2', '1', 'single_choice', '0', '20.0', '0.0'), ('9', '2', '3', '4', 'determine', '0', '20.0', '0.0'), ('10', '2', '4', '3', 'essay', '0', '20.0', '0.0'), ('11', '2', '5', '5', 'essay', '0', '20.0', '0.0');
COMMIT;

-- ----------------------------
--  Table structure for `testpaper_item_result`
-- ----------------------------
DROP TABLE IF EXISTS `testpaper_item_result`;
CREATE TABLE `testpaper_item_result` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '试卷题目做题结果ID',
  `itemId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '试卷条目ID',
  `testId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '试卷ID',
  `testPaperResultId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '试卷结果ID',
  `userId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '做题人ID',
  `questionId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '题目ID',
  `status` enum('none','right','partRight','wrong','noAnswer') NOT NULL DEFAULT 'none' COMMENT '结果状态',
  `score` float(10,1) NOT NULL DEFAULT '0.0' COMMENT '得分',
  `answer` text COMMENT '回答',
  `teacherSay` text COMMENT '老师评价',
  PRIMARY KEY (`id`),
  KEY `testPaperResultId` (`testPaperResultId`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `testpaper_item_result`
-- ----------------------------
BEGIN;
INSERT INTO `testpaper_item_result` VALUES ('1', '0', '1', '1', '2', '1', 'right', '30.0', '[\"0\"]', null), ('2', '0', '1', '1', '2', '2', 'right', '30.0', '[\"0\"]', null), ('3', '0', '1', '1', '2', '3', 'wrong', '30.0', '[\"\\u80af\\u5b9a\\u723d\\u5566\"]', '不错不错，挺会装逼的'), ('4', '0', '1', '2', '1', '1', 'right', '30.0', '[\"0\"]', null), ('5', '0', '1', '2', '1', '2', 'right', '30.0', '[\"0\"]', null), ('6', '0', '1', '2', '1', '3', 'none', '0.0', '[\"\\u5fc5\\u987b\\u723d\"]', null);
COMMIT;

-- ----------------------------
--  Table structure for `testpaper_result`
-- ----------------------------
DROP TABLE IF EXISTS `testpaper_result`;
CREATE TABLE `testpaper_result` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '试卷结果ID',
  `paperName` varchar(255) NOT NULL DEFAULT '' COMMENT '试卷名称',
  `testId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '试卷ID',
  `userId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '做卷人ID',
  `score` float(10,1) unsigned NOT NULL DEFAULT '0.0' COMMENT '总分',
  `objectiveScore` float(10,1) unsigned NOT NULL DEFAULT '0.0' COMMENT '主观题得分',
  `subjectiveScore` float(10,1) unsigned NOT NULL DEFAULT '0.0' COMMENT '客观题得分',
  `teacherSay` text COMMENT '老师评价',
  `rightItemCount` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '正确题目数',
  `passedStatus` enum('none','passed','unpassed') NOT NULL DEFAULT 'none' COMMENT '考试通过状态，none表示该考试没有',
  `limitedTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '试卷限制时间(秒)',
  `beginTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '开始时间',
  `endTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '结束时间',
  `updateTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后更新时间',
  `active` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `status` enum('doing','paused','reviewing','finished') NOT NULL COMMENT '状态',
  `target` varchar(255) NOT NULL DEFAULT '' COMMENT '试卷结果所属对象',
  `checkTeacherId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '批卷老师ID',
  `checkedTime` int(11) NOT NULL DEFAULT '0' COMMENT '批卷时间',
  `usedTime` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `testpaper_result`
-- ----------------------------
BEGIN;
INSERT INTO `testpaper_result` VALUES ('1', '装逼考试', '1', '2', '90.0', '60.0', '30.0', '用心、专注、坚持，你能做的更好的！', '2', 'none', '30', '1411209196', '1411209214', '0', '1', 'finished', 'course-1/lesson-5', '1', '1411209352', '17'), ('2', '装逼考试', '1', '1', '0.0', '60.0', '0.0', null, '2', 'none', '30', '1419056640', '1419056654', '0', '1', 'reviewing', 'course-1/lesson-5', '0', '1419056654', '13');
COMMIT;

-- ----------------------------
--  Table structure for `theme_config`
-- ----------------------------
DROP TABLE IF EXISTS `theme_config`;
CREATE TABLE `theme_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `config` text,
  `confirmConfig` text,
  `allConfig` text,
  `updatedTime` int(11) NOT NULL DEFAULT '0',
  `createdTime` int(11) NOT NULL DEFAULT '0',
  `updatedUserId` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `upgrade_logs`
-- ----------------------------
DROP TABLE IF EXISTS `upgrade_logs`;
CREATE TABLE `upgrade_logs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `remoteId` int(11) NOT NULL COMMENT 'packageId',
  `installedId` int(11) DEFAULT NULL COMMENT '本地已安装id',
  `ename` varchar(32) NOT NULL COMMENT '名称',
  `cname` varchar(32) NOT NULL COMMENT '中文名称',
  `fromv` varchar(32) DEFAULT NULL COMMENT '初始版本',
  `tov` varchar(32) NOT NULL COMMENT '目标版本',
  `type` smallint(6) NOT NULL COMMENT '升级类型',
  `dbBackPath` text COMMENT '数据库备份文件',
  `srcBackPath` text COMMENT '源文件备份地址',
  `status` varchar(32) NOT NULL COMMENT '状态(ROLLBACK,ERROR,SUCCESS,RECOVERED)',
  `logtime` int(11) NOT NULL COMMENT '升级时间',
  `uid` int(10) unsigned NOT NULL COMMENT 'uid',
  `ip` varchar(32) DEFAULT NULL COMMENT 'ip',
  `reason` text COMMENT '失败原因',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='本地升级日志表';

-- ----------------------------
--  Table structure for `upload_files`
-- ----------------------------
DROP TABLE IF EXISTS `upload_files`;
CREATE TABLE `upload_files` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '上传文件ID',
  `hashId` varchar(128) NOT NULL DEFAULT '' COMMENT '文件的HashID',
  `targetId` int(11) NOT NULL COMMENT '所存目标ID',
  `targetType` varchar(64) NOT NULL DEFAULT '' COMMENT '目标类型',
  `filename` varchar(1024) NOT NULL DEFAULT '' COMMENT '文件名',
  `ext` varchar(12) NOT NULL DEFAULT '' COMMENT '后缀',
  `size` bigint(20) NOT NULL DEFAULT '0' COMMENT '文件大小',
  `etag` varchar(256) NOT NULL DEFAULT '' COMMENT 'ETAG',
  `length` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '长度（音视频则为时长，PPT/文档为页数）',
  `convertHash` varchar(128) NOT NULL DEFAULT '' COMMENT '文件转换时的查询转换进度用的Hash值',
  `convertStatus` enum('none','waiting','doing','success','error') NOT NULL DEFAULT 'none' COMMENT '文件转换状态',
  `convertParams` text COMMENT '文件转换参数',
  `metas` text COMMENT '元信息',
  `metas2` text COMMENT '元信息',
  `type` enum('document','video','audio','image','ppt','other') NOT NULL DEFAULT 'other' COMMENT '文件类型',
  `storage` enum('local','cloud') NOT NULL COMMENT '文件存储方式',
  `isPublic` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否公开文件',
  `canDownload` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否可下载',
  `updatedUserId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新用户名',
  `updatedTime` int(10) unsigned DEFAULT '0' COMMENT '文件最后更新时间',
  `createdUserId` int(10) unsigned NOT NULL COMMENT '文件上传人',
  `createdTime` int(10) unsigned NOT NULL COMMENT '文件上传时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `convertHash` (`convertHash`(64)),
  UNIQUE KEY `hashId` (`hashId`(120))
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `upload_files`
-- ----------------------------
BEGIN;
INSERT INTO `upload_files` VALUES ('1', 'coursematerial/1/2014918103227-cgnt41.xlsx', '1', 'coursematerial', 'Agent新旧版差异对比.xlsx', 'xlsx', '37243', '', '0', 'ch-coursematerial/1/2014918103227-cgnt41.xlsx', 'none', null, null, null, 'document', 'local', '0', '0', '1', '1411050747', '1', '1411050747'), ('2', 'coursematerial/1/2014918103228-muweki.xlsx', '1', 'coursematerial', '长安标致雪铁龙汽车 中欧平台需求 - 20140918.xlsx', 'xlsx', '11171', '', '0', 'ch-coursematerial/1/2014918103228-muweki.xlsx', 'none', null, null, null, 'document', 'local', '0', '0', '1', '1411050748', '1', '1411050748');
COMMIT;

-- ----------------------------
--  Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `email` varchar(128) NOT NULL COMMENT '用户邮箱',
  `password` varchar(64) NOT NULL COMMENT '用户密码',
  `salt` varchar(32) NOT NULL COMMENT '密码SALT',
  `uri` varchar(64) NOT NULL DEFAULT '' COMMENT '用户URI',
  `nickname` varchar(64) NOT NULL COMMENT '昵称',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT '头像',
  `tags` varchar(255) NOT NULL DEFAULT '' COMMENT '标签',
  `type` varchar(32) NOT NULL COMMENT 'default默认为网站注册, weibo新浪微薄登录',
  `point` int(11) NOT NULL DEFAULT '0' COMMENT '积分',
  `coin` int(11) NOT NULL DEFAULT '0' COMMENT '金币',
  `smallAvatar` varchar(255) NOT NULL DEFAULT '' COMMENT '小头像',
  `mediumAvatar` varchar(255) NOT NULL DEFAULT '' COMMENT '中头像',
  `largeAvatar` varchar(255) NOT NULL DEFAULT '' COMMENT '大头像',
  `emailVerified` tinyint(1) NOT NULL DEFAULT '0' COMMENT '邮箱是否为已验证',
  `setup` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否初始化设置的，未初始化的可以设置邮箱、昵称。',
  `roles` varchar(255) NOT NULL COMMENT '用户角色',
  `promoted` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否为推荐',
  `promotedTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '推荐时间',
  `locked` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否被禁止',
  `loginTime` int(11) NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `loginIp` varchar(64) NOT NULL DEFAULT '' COMMENT '最后登录ID',
  `loginSessionId` varchar(255) NOT NULL DEFAULT '' COMMENT '最后登录会话ID',
  `approvalTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '实名认证时间',
  `approvalStatus` enum('unapprove','approving','approved','approve_fail') NOT NULL DEFAULT 'unapprove' COMMENT '实名认证状态',
  `newMessageNum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '未读私信数',
  `newNotificationNum` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '未读消息数',
  `createdIp` varchar(64) NOT NULL DEFAULT '' COMMENT '注册IP',
  `createdTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `nickname` (`nickname`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `user`
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('1', 'tongzhenke@gmail.com', 'Ee2OEaBXKuQMGg8E2a6111QDAGqByTXqsKbAAwgKyMI=', 'lvihq8js6lckocg0wcs88wcw888o00k', '', '熊先生', 'test', '', 'default', '0', '0', 'public://user/2014/09-18/231820c559be169722.jpg', 'public://user/2014/09-18/231820c54849225846.jpg', 'public://user/2014/09-18/231820c50d4c900089.jpg', '0', '1', '|ROLE_USER|ROLE_TEACHER|ROLE_SUPER_ADMIN|', '0', '0', '0', '1427436679', '::1', '74d75c6044995267dcd9db1a5da31c27', '1419140338', 'approve_fail', '0', '0', '', '1410920900'), ('2', 'java_rainy@126.com', 'Aysc6zxhCxuDiVzrYY1tF0wVbEwBZJ5+O9oRwl9Bx5Q=', 'gc0juz28mz48oosgk0s4wo4wkk48k88', '', '阿蓝', '神', '', 'default', '0', '0', 'public://user/2014/09-19/102636c82199607128.jpg', 'public://user/2014/09-19/102636c81404161605.jpg', 'public://user/2014/09-19/102636c7d801999730.jpg', '0', '1', '|ROLE_USER|ROLE_TEACHER|', '0', '0', '0', '1411301877', '::1', '6b87be0a114bec05631832832cc20e18', '1419140336', 'approve_fail', '0', '1', '::1', '1411057526'), ('3', '406419397@qq.com', 'dH9bWekAeYv1sjqFEGui6LYU7bLYDR7v36YT4adSze4=', 'br06od10hrswog84w0sgsg0o44w8gkk', '', '阿柯', '', '', 'default', '0', '0', '', '', '', '0', '1', '|ROLE_USER|ROLE_ADMIN|', '0', '0', '0', '1427355540', '::1', '9b6a0d026adef5afac18a4e82acb2d60', '0', 'unapprove', '0', '0', '::1', '1411093825'), ('4', 'denglingfeng@shsnc.com', 'HDeDJYgxRVaJX2Ys02VZ4b0JKN98T4yYj1kUM0IoanY=', '1ugakc43zvk0s8swko88k40skcs4go8', '', '凌峰', '', '', 'default', '0', '0', '', '', '', '0', '1', '|ROLE_USER|', '0', '0', '0', '1427421967', '::1', '62fc293a1d299b7543ddd7de374e9be5', '0', 'unapprove', '1', '0', '::1', '1411105908');
COMMIT;

-- ----------------------------
--  Table structure for `user_approval`
-- ----------------------------
DROP TABLE IF EXISTS `user_approval`;
CREATE TABLE `user_approval` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '用户认证ID',
  `userId` int(10) NOT NULL COMMENT '用户ID',
  `idcard` varchar(24) NOT NULL DEFAULT '' COMMENT '身份证号',
  `faceImg` varchar(500) NOT NULL DEFAULT '' COMMENT '认证正面图',
  `backImg` varchar(500) NOT NULL DEFAULT '' COMMENT '认证背面图',
  `truename` varchar(255) DEFAULT NULL COMMENT '真实姓名',
  `note` text COMMENT '认证信息',
  `status` enum('unapprove','approving','approved','approve_fail') NOT NULL COMMENT '是否通过：1是 0否',
  `operatorId` int(10) unsigned DEFAULT NULL COMMENT '审核人',
  `createdTime` int(10) NOT NULL DEFAULT '0' COMMENT '申请时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='用户认证表';

-- ----------------------------
--  Records of `user_approval`
-- ----------------------------
BEGIN;
INSERT INTO `user_approval` VALUES ('1', '1', '430621198907146114', '/Users/me/htdocs/edusoho/app/data/private_files/approval/userFaceImg11410921046.png', '/Users/me/htdocs/edusoho/app/data/private_files/approval/userbackImg11410921046.png', '童桢柯', null, 'approving', null, '1410921046'), ('2', '2', '430621198907146421', '/Users/me/htdocs/edusoho/app/data/private_files/approval/userFaceImg21411093452.jpg', '/Users/me/htdocs/edusoho/app/data/private_files/approval/userbackImg21411093452.jpg', '童桢柯', null, 'approving', null, '1411093452'), ('3', '2', '', '', '', null, '管理员撤销', 'approve_fail', '1', '0'), ('4', '1', '', '', '', null, '管理员撤销', 'approve_fail', '1', '0');
COMMIT;

-- ----------------------------
--  Table structure for `user_bind`
-- ----------------------------
DROP TABLE IF EXISTS `user_bind`;
CREATE TABLE `user_bind` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户绑定ID',
  `type` varchar(64) NOT NULL COMMENT '用户绑定类型',
  `fromId` varchar(32) NOT NULL COMMENT '来源方用户ID',
  `toId` int(10) unsigned NOT NULL COMMENT '被绑定的用户ID',
  `token` varchar(255) NOT NULL DEFAULT '' COMMENT 'oauth token',
  `refreshToken` varchar(255) NOT NULL DEFAULT '' COMMENT 'oauth refresh token',
  `expiredTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'token过期时间',
  `createdTime` int(10) unsigned NOT NULL COMMENT '绑定时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `type` (`type`,`fromId`),
  UNIQUE KEY `type_2` (`type`,`toId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `user_field`
-- ----------------------------
DROP TABLE IF EXISTS `user_field`;
CREATE TABLE `user_field` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fieldName` varchar(100) NOT NULL DEFAULT '',
  `title` varchar(1024) NOT NULL DEFAULT '',
  `seq` int(10) unsigned NOT NULL,
  `enabled` int(10) unsigned NOT NULL DEFAULT '0',
  `createdTime` int(100) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `user_fortune_log`
-- ----------------------------
DROP TABLE IF EXISTS `user_fortune_log`;
CREATE TABLE `user_fortune_log` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `number` int(10) NOT NULL,
  `action` varchar(20) NOT NULL,
  `note` varchar(255) NOT NULL DEFAULT '',
  `createdTime` int(11) NOT NULL,
  `type` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `user_profile`
-- ----------------------------
DROP TABLE IF EXISTS `user_profile`;
CREATE TABLE `user_profile` (
  `id` int(10) unsigned NOT NULL COMMENT '用户ID',
  `truename` varchar(255) NOT NULL DEFAULT '' COMMENT '真实姓名',
  `idcard` varchar(24) NOT NULL DEFAULT '' COMMENT '身份证号码',
  `gender` enum('male','female','secret') NOT NULL DEFAULT 'secret' COMMENT '性别',
  `iam` varchar(255) NOT NULL DEFAULT '' COMMENT '我是谁',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `city` varchar(64) NOT NULL DEFAULT '' COMMENT '城市',
  `mobile` varchar(32) NOT NULL DEFAULT '' COMMENT '手机',
  `qq` varchar(32) NOT NULL DEFAULT '' COMMENT 'QQ',
  `signature` text COMMENT '签名',
  `about` text COMMENT '自我介绍',
  `company` varchar(255) NOT NULL DEFAULT '' COMMENT '公司',
  `job` varchar(255) NOT NULL DEFAULT '' COMMENT '工作',
  `school` varchar(255) NOT NULL DEFAULT '' COMMENT '学校',
  `class` varchar(255) NOT NULL DEFAULT '' COMMENT '班级',
  `weibo` varchar(255) NOT NULL DEFAULT '' COMMENT '微博',
  `weixin` varchar(255) NOT NULL DEFAULT '' COMMENT '微信',
  `site` varchar(255) NOT NULL DEFAULT '' COMMENT '网站',
  `intField1` int(11) DEFAULT NULL,
  `intField2` int(11) DEFAULT NULL,
  `intField3` int(11) DEFAULT NULL,
  `intField4` int(11) DEFAULT NULL,
  `intField5` int(11) DEFAULT NULL,
  `dateField1` date DEFAULT NULL,
  `dateField2` date DEFAULT NULL,
  `dateField3` date DEFAULT NULL,
  `dateField4` date DEFAULT NULL,
  `dateField5` date DEFAULT NULL,
  `floatField1` float(10,2) DEFAULT NULL,
  `floatField2` float(10,2) DEFAULT NULL,
  `floatField3` float(10,2) DEFAULT NULL,
  `floatField4` float(10,2) DEFAULT NULL,
  `floatField5` float(10,2) DEFAULT NULL,
  `varcharField1` varchar(1024) DEFAULT NULL,
  `varcharField2` varchar(1024) DEFAULT NULL,
  `varcharField3` varchar(1024) DEFAULT NULL,
  `varcharField4` varchar(1024) DEFAULT NULL,
  `varcharField5` varchar(1024) DEFAULT NULL,
  `varcharField6` varchar(1024) DEFAULT NULL,
  `varcharField7` varchar(1024) DEFAULT NULL,
  `varcharField8` varchar(1024) DEFAULT NULL,
  `varcharField9` varchar(1024) DEFAULT NULL,
  `varcharField10` varchar(1024) DEFAULT NULL,
  `textField1` text,
  `textField2` text,
  `textField3` text,
  `textField4` text,
  `textField5` text,
  `textField6` text,
  `textField7` text,
  `textField8` text,
  `textField9` text,
  `textField10` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `user_profile`
-- ----------------------------
BEGIN;
INSERT INTO `user_profile` VALUES ('1', '童桢柯', '430621198907146114', 'male', '', null, '', '18680211111', '4444444', 'test', 'I have a try.', 'test', 'test', '', '', 'http://weibo.com/u/2979345940?wvr=5&lf=reg', '4444444', 'http://user.qzone.qq.com/406419397?ptsig=iMhdoCWPp8h*4HH2l88uptOHAJPqH0TV1PMq7V8UHv4_', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), ('2', '童桢柯', '430621198907146421', 'male', '', null, '', '13313131313', '', '哥是个传说', '不要崇拜哥，哥只是个传说', '叉叉公司', 'COC职业玩家', '', '', '', '', '', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), ('3', '', '', 'secret', '', null, '', '', '', null, null, '', '', '', '', '', '', '', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), ('4', '', '', 'secret', '', null, '', '', '', null, null, '', '', '', '', '', '', '', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
COMMIT;

-- ----------------------------
--  Table structure for `user_token`
-- ----------------------------
DROP TABLE IF EXISTS `user_token`;
CREATE TABLE `user_token` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'TOKEN编号',
  `token` varchar(64) NOT NULL COMMENT 'TOKEN值',
  `userId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'TOKEN关联的用户ID',
  `type` varchar(255) NOT NULL COMMENT 'TOKEN类型',
  `data` text NOT NULL COMMENT 'TOKEN数据',
  `times` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'TOKEN的校验次数限制(0表示不限制)',
  `remainedTimes` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'TOKE剩余校验次数',
  `expiredTime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'TOKEN过期时间',
  `createdTime` int(10) unsigned NOT NULL COMMENT 'TOKEN创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `token` (`token`(60))
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `user_token`
-- ----------------------------
BEGIN;
INSERT INTO `user_token` VALUES ('1', 'm729nz1t1dwgg0k0wkk4w8444ggsk4g', '1', 'fileupload', 's:2:\"N;\";', '0', '0', '1411057947', '1411050747'), ('2', 'fbjpjkplp9ckcw0skkwk8gg0s00kkow', '1', 'fileupload', 's:2:\"N;\";', '0', '0', '1411057948', '1411050748'), ('3', 'nejxw2ialaocs0gwkows0go8wck0s8s', '2', 'email-verify', 's:2:\"N;\";', '0', '0', '1411143927', '1411057527');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
